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.
N369KMHoon David DBA · Wolf Creek, MTN369MMurrell James Sr · Douglas, AZN369MBBarnes Matthew L · Pacific Palisades, CAN369METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN369NEPeter Travis E · Evansville, WYN369PPPositive Attitude Ia LLC · Gaithersburg, MDN369QCHosking Aerobatics · Bountiful, UTFirst renewal noticeN369RAShaffer Patricia G · Texarkana, TXN369RJD & S Aviation LLC · Spring, TXN369RNTurtle Air LLC · Sarasota, FLN369RVEiland Dean L · Aubrey, TXN369SACaton William D · Irving, TXN369SESkyfusion II LLC · Atlanta, GAN369SPXin Han Aviation LLC · Helena, MTN369SRChopper Shots LLC · West Bath, MEN369SSEvolution Enterprises LLC · Wilmington, DEN369TWChristiansen Aviation LLC · Wilmington, DEN369WBSale Reported · Knoxville, TNSale reportedN369WPLego Aviation LLC · Grimes, IAN369XHibbs Curtis M · Houston, TXN369XHFly Yawa Aviation LLC · Statesboro, GAN36AOral & Maxillofacial Surgery Of Carbondale Inc · Carbondale, ILN36AAPortnoy Ralph · Hollywood, MDN36ABNg Turf LLC · Whitesburg, GAN36AESokolowski Daniel J · Clear Lake, IAN36AFLewis Richard M Jr · Deltaville, VAN36AHHall Timothy L · Papillion, NEN36AJFurst A J · Coral Gables, FLN36ALCuozzo Alfred F · Eagle Point, ORN36APAnalysis Inc · Grand Junction, CON36ARArkansas Department Of Aeronautics · Little Rock, ARN36ASMoore Brothers Company Inc · Staunton, VAN36AVCook Greg R · Willis, TXN36AZTc International Inc · Whittier, CAN36BGPerez Colbert Md Pa · Lubbock, TXN36BHHobo LLC · Milford, IAN36BKBiro Manufacturing Co Inc · Marblehead, OHN36BNMarshall Baron Robert · Marion, MTN36BRRegistered aircraftN36BSBarnard Brian D · Tallahassee, FLN36CEHawkes Delray · Sequim, WAN36CGDay Edwin Daniel · Richland, WAN36CNBonanza Aircraft Partners LLC · Sugar Land, TXN36CRRacer Aviation LLC · Moorestown, NJN36CTExecutive Mission LLC · Round Rock, TXN36CWC2 Aviation LLC · Louisville, KYN36DSummer Winds II LLC · Lafayette, INN36DBWalsh Terence G · Fort Lauderdale, FLN36DEMajor Tom LLC · Grottoes, VAN36DGRegistered aircraft
Back to AD 2007-04-19 R1