AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5010ADickson Roger · Saint Helena, CAN5010SAeroflyte LLC · Glastonbury, CTN5010TN5010t LLC · Arcadia, OKN5010WGayler Meredith M · Indio, CAN5010YSoloy Samuel K · Wasilla, AKN5011KSky Helicopters Inc · Desoto, TXN5011PFinkey Jason B · Leonidas, MIN5011QBoh-Air Corporation · Jenks, OKN5011TAv8 Holdings LLC · Wilmington, DEN5011UAtp Aircraft 2 LLC · Wilmington, DEN5011WSky Helicopters Inc · Desoto, TXN5011XPro Air LLC · Alexandria, LAN5012AEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeN5012MBig Bend Community College · Moses Lake, WAN5012NSouto Nathan J · Clearwater, FLN5012REmd Aviation LLC · Carlsbad, CAN5012WAllen Michel D · Essex Jct, VTN5013QTesini Allan J · Zephyrhills, FLN5013RBarxbar Aviation LLC · Mesa, AZN5013SFlightworks LLC · North Myrtle Beach, SCN5013TDasilvafontoura Peterson · Santa Clarita, CAN5014DHall Matthew A · Coeur D Alene, IDN5014PSky Valley Aviation LLC · Waverly, IAN5014RCooper Flying Inc · Lamesa, TXN5014SGandy Austin T · Channelview, TXN5015WCarman Christopher S · Iuka, MSN5016DCain Arthur W · Kenilworth, NJRegistration revokedN5016SMccartan Gary · Pocahontas, IAN5017DGraham Thomas V · San Rafael, CAN5017MNo Limits Aviation Inc · Lincoln, MTN5017RR&R Leasing LLC · Fargo, NDN5017UBen Allen LLC · Wilmington, DEN5018PTseng Leon Y · Tucson, AZN5018UFlight Gate LLC · Wilton, CAN5018YHighland Rim Aviation LLC · Springfield, TNN50193Folsom Gary A · Marianna, FLN5019DNobel John C · Brandon, FLN5019ERegistration Pending · Wilbur, WARegistration pendingN5019JFairley Stephen · Petal, MSN5019SGordon Patricia I · Desoto, TXN5019WShipley Kelly R · Astoria, ORN501ACNka Inc · Wilmington, DEN501AHOlah Gregory J · High Point, NCN501BAFalcon Air LLC · Orlando, FLN501BSBlue Skies Enterprises Of Texas · Richmond, TXN501CRTarno Suzzan · Avondale, AZN501DCExecutive Aviation LLC · Peoria, AZN501DSChilson Jacob Shane · Willits, CAN501DWParmar Bluffs LLC · Parker, SDN501ERVista Air Inc · Pacoima, CA
Back to AD 2007-04-19 R1