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.
N6532CQuartarolo Pete · Santa Rosa, CAN6532FCouch Walter Jack · Patterson, LAN6532JGarner Aviation LLC · Tampa, FLN65339Shaw Andrew G · Huntingdon, PAN6533JPaulson James L · Lawrenceville, NJN6533LNorthcutt Cecil W III · Ponder, TXN6533W21 Luna LLC · Phoenix, AZN6534BMurphy Timothy · Lake City, FLN6534LAndreassen Andrew R · Pleasanton, NEN6534UHuertas Andrew · Van Nuys, CAN6535GBbjs Investments LLC · Burlington, WIN6535HAerial Sign North Inc · Lakewood, NJN6535LRodick John M · Hanson, MAN6535TDobson Richard W · Phenix City, ALN65369Burrill Michael E Jr · Medford, ORN6536JCooper David M · Sedona, AZN6536PWings Over Texas Holdings LLC · Denton, TXN6536VTran Dai A · Rancho Cucamonga, CAN6536WDenny David F · Bath, NCN6537DCunningham Edward A · Washington, DCN6537FWheels Up Aviation LLC · Pittsburgh, PAN6537HRivers Robert A · Oxford, NCN6537JTimer Anna Mae · Wildwood Crest, NJN6538FMbk Leasing And Consulting LLC · Lakeland, FLN6538JBerra Robert J · Burtonsville, MDN6538RFunnell John R · Cedar Park, TXN6538VSommer Timothy T · Combined Locks, WIN65396S Dacy Enterprises Inc · Harvard, ILN65398Seeley Timothy C Trustee · Chico, CAN6539HAbove The Haze LLC · San Lorenzo, CAN6539RSpencer Alexander Joshua · North Las Vegas, NVN6539WYounglove Donald L · Mendota, ILN653BQQuilty Stephen M · Abingdon, VAN653CHKelley Aviation Consultants LLC · S Williamsport, PAN653FTFlorida Institute Of Technology Inc · Melbourne, FLN653JFRegistration Pending · Elizabeth, NJRegistration pendingN653KBSkyhawk Aviation Inc · Marietta, GAN653MCDaily Joshua · Rochester, WAN653PSCorcoran Matthew L · Redondo Beach, CAN653QPhillips Robert B · Coshocton, OHN653RVRoberts Todd L · Friday Harbor, WAN653SHGivens Tyler · La Vernia, TXN653SMMckinney Steven R · Hamersville, OHN653SRVertex Aviation Services LLC · Burlington, WAN653TSSturm Mark I · Albuquerque, NMN653WChesebro Ben D · Oro Valley, AZN654Roderick Paul E · Talkeetna, AKN65401Pea-Wayman Flight LLC · Daytona Beach, FLN65407Clemson Flying Club Inc · Seneca, SCN65408Hendrix Aviation Inc · Plantation, FL
Back to AD 90-04-06 R1