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.
N372BHLewis University · Romeoville, ILN372CCLemieux Kenneth G · Oneida, TNN372CPCivil Air Patrol · Maxwell Afb, ALN372DLLebarron David A · Meeker, CON372FCHeartland Aviation Inc · Alliance, NEN372FDDe Santi Michael P · Fort Lupton, CON372GGIal Corp · Lewes, DEN372GMShetterly Gregory W · Warrensburg, MON372HBUnited States Air Force 21 Force Support Squadron · Colorado Springs, CON372HZDesmarais Daniel R · Soldotna, AKN372LFShoemaker William · Manns Choice, PAN372MGrabowski Parker J · Belgrade, MTN372MEAircraft Partner Holdings Inc Trustee · BerlinN372MKNorth Star Aviation Inc · Mankato, MNN372NMShelter Michael R · Sandy Lake, PAN372RVJordan Stephen L · Indian Springs, ALN372SAJoe Wagner IV Construction LLC · Zebulon, NCN372TBeautte James E · Fairland, OKN372TADap Aviation LLC · Reston, VAN372TWTom Wood Aviation · Fishers, INN372VUPerry Robert P · Chelan, WAN372WBCornelia Adair LLC · Amarillo, TXN372ZLuy Jonathan Carl · Sutter Creek, CAN373Clayland Walter · San Rafael, CAN37302Elrod Jason A · Seattle, WAN37306Frescomar USA LLC · Miami, FLN3730DLedbetter Jeffrey Allen · Huntley, ILN3730HFox Valley Aero Club Inc · Oshkosh, WIN3730KCloutier Felix S · Fond Du Lac, WIN3730MWilcom LLC · Hammond, LAN3730TNational Energy Conservers Inc · West Linn, ORN3730UWarren Kevin · Berger, MON3730WEye South Equipment LLC · Greenwood, MSN37315Atlantic Coast Contractors Inc · Denver, NCN3731DMond Darcee · Galena, ILN3731FCarder Wiley C · Cameron Park, CAN3731GMaxwell Truck & Equipment LLC · State College, PAN3731QMoore J D · Lawson, MON3731YHaglin Dana · Erie, CON37321Hamilton Janet S · Townsend, GAN3732DClark William M · Ann Arbor, MIN3732PHusain Arif · Pipersville, PAN3732QMyers Greg · Amarillo, TXN3732TOancea Traian · Oakdale, CAN3732UGifford Tracy G · Stephenville, TXN3733DSt Charles Flying Service Inc · Portage Des Sioux, MON3733GPilots Choice Aviation Equipment Leasing Co · Georgetown, TXN3733PCottrell Mark C · Leitchfield, KYN3733QChalender Robert C · Cocoa, FLN3733TTudor David M · Seaford, DE
Back to AD 2007-04-19 R1