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.
N2935FPeirce Brenden D · Eatonville, WAN2935GWilliams Herbert B Jr · Pensacola, FLN2935LCrc Medical Staffing Inc · Mansfield, LAN2935NMartineau Robert Tyler · Crested Butte, CON2935SJacksonville Airport Authority · Jacksonville, ILN2935UBraner Richard C · Oakdale, CAN2935VHungerford Mark T · Swanton, VTN2935XStelzer David C · Vermilion, OHN2935ZTittle James L · Pembine, WIN29362Registered aircraftN29366Bond Joseph C · Arlington, TXN29367Dulin Jim · Valparaiso, INN2936CSale Reported · Stoughton, WISale reportedN2936EHansen Mark A Trustee · Long Beach, CAN2936LWencko Paul Andrei · Saint Petersburg, FLN2936MHoward Brian M · Boise, IDN2936NTailwinds Aviation LLC · Crystal Lake, ILN2936ZSzostak Edward M · San Diego, CAN29374Heartland Aviation Inc · Alliance, NEN29376Registered aircraftN29377Duncan John M · Owingsville, KYN29379Sattler Russell P · Brooksville, FLN2937NDelaware State University Aviation Program · Dover, DEN2937PSmith Caleb · Wasilla, AKN2937RCross Winds Flying Club Inc · Bloomington, ILN2937XOrtega Tobin W · Juneau, AKN2937YSkylane Inc · Moose Lake, MNN29389Otc Aviation LLC · Deer Creek, MNN2938AKoons John D · Waterville, MEN2938CKeller Dylan M · Meridian, IDN2938FFly Gateway Aviation Institute · New Castle, DEN2938LAmend Keith R · Hagerman, IDN2938YFoster Amy L DBA · Jarrell, TXN29395Hand Randall A · Bonifay, FLN2939ARwrb LLC · Conway, ARN2939FGeorges Aerial Spraying Service Inc · Sutton, NEN2939JCaballeros Aircraft LLC · Snohomish, WAN2939LDonahue Paul · West Palm Beach, FLN2939PEcg Lake Flyers Inc · Fayetteville, GAN2939XDahl Skye T · Camas, WAN2939YDanzy Michael R · Oakdale, LAN2939ZWozniak Robert Frank Jr · Sparrows Point, MDN293CAChoice Aviation LLC · Hamilton, MTN293CMRegistration Pending · Royal Palm Beach, FLRegistration pendingN293CPCivil Air Patrol · Maxwell Afb, ALN293DBCampo Peter J · Los Gatos, CAN293GMGeco Inc · Wilmington, DEN293HPThree View Flyers LLC · Hauppauge, NYN293LAPiper 3 LLC · Chestnut Ridge, NYN293MAKrogman James D · Danube, MN
Back to AD 2007-04-19 R1