AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7851NWilson Steven Alfred Trustee · Runnells, IAN7851VJensen Jared E · Preston, IDN7851WJl Wings LLC · Prosper, TXN78520Jdb Aviation Inc · Merritt Island, FLN78523Sunderman Randy · Norfolk, NEN78525Aero II Inc · Spartanburg, SCN78526Miklus Michael III · Saint Georges, DEN7852NDelatte Joseph S · Gonzales, LAN7852VCobb Brian P · Tucson, AZN7852WSouthall David S · Poquoson, VAN7852YBordlemay John J · Lewisberry, PAN78531Goodridge Flying Club Inc · Goodridge, MNN78532Resop Jason L · Chandler, AZN78535Langrell Sterline S · Aurora, ORN78536Jazun Carlos Walter · Parker, CON78538Drover Michael A · Winter, WIN7853CDue West Aviation LLC · Brandon, SDN7853HAlaska Department Of Fish And Game · Nome, AKN7853NLong Nels B · Caledonia, OHN78541Ayres Jon S · Ijamsville, MDN78542Tolmachev Nikolay A · Anchorage, AKN78546Haeuser Edwin J · Rochester, MNFirst renewal noticeN78547Jerry Luttrell And Associates Inc · Kearney, MON78548Bakalar Flying Club Inc · Columbus, INN7854GNeuschaefer George H · White Hills, AZN7854JMilstead Eric N · Tampa, FLN7854PSarpy Aviation LLC · Hysham, MTN78553Shop Branch Equipment Co Inc · Marble Falls, TXN78554Sullivan Shaun K · Midwest City, OKFirst renewal noticeN78555Schultes James F Jr · West Deptford, NJN78558Lindemann Robin · Anchorage, AKN7855GAlpenglow Air 3 LLC · Anchorage, AKN7855SCse Aviation LLC · Plymouth, MAN7855VRyan Willam R · Jupiter, FLN7855YParrish Aviation Flight Academy LLC · Southlake, TXN78561Gayler Larry · Thermal, CAN78564Damico Anthony R · Anchorage, AKN78565Sousa Gerald L · Talkeetna, AKN78567Frazier Forrest Alan · Taylors, SCN7856GMitchell Lindsey T · Chesnee, SCN7856HPratt John Jr · Anchorage, AKN7856N56 November LLC · Brighton, CON7856VLampkin Derrick J · Bethesda, MDN7856WN7856w LLC · Shelocta, PAN7856YEastern Technical Corp · Martinsburg, WVN78573Hohmann Courtney P · Jacksonville, FLN78574Johns Robert A · Anchorage, AKN78575Hoppe Nicholas J · Big Lake, AKN78579Hamilton George D · Bandera, TXN7857DHeinze Bill · Ashley, MI
Back to AD 90-04-06 R1