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.
N2PUEastern Stearman Inc Trustee · Leesburg, VAN2PWXin Han Aviation LLC · Atwater, CAN2PXBliss James · Corpus Christi, TXN2QHOconnor Lloyd T · Dillingham, AKN2QTBoucher Bobbi · Fredericksburg, VAN2REEtzler Richard D · Durango, CON2RGGrosch Richard C · Granite Bay, CAFirst renewal noticeN2RHRene M Haas Inc · North Chatham, MAN2RSSlippy Timothy W · Bothell, WAN2RVMccartney Steven R · Camarillo, CAN2RXJbs Enterprises LLC · Hamilton, MTN2SAInternational Air Services Inc Trustee · Carson City, NVN2SGKcsi Aerial Patrol · Bakersfield, CAN2SKRegistered aircraftN2SLLowe Aviation LLC · Bountiful, UTN2SSFlying M Aircraft LLC · Kuna, IDN2STJefson Lyle S · Shelbyville, ILN2SVPiper J D · Lawrenceville, ILN2TLAlexander Terry W · Hayward, CAN2TMMorgan Todd · Bonita, CAN2TQFlying M Enterprises LLC · Snowville, UTN2TTLawthers William T · Tehachapi, CAN2TYUridel Douglas DBA · Leesburg, FLN2UGBaker Gregory L · Hilton Head Island, SCN2UMHepfer John Edward · Midland, TXN2UQCox Paul Bartlett · Granbury, TXN2UTDemaeyer Thomas A · Fort Lauderdale, FLN2VCPray Aviation Inc · Augusta, KSN2VGWong Jonathan · Phoenix, AZN2VQN2vq LLC · Manassas, VAN2VRRead Andrew R · Milwaukee, WIN2VTRegistration Pending · Fort Pierce, FLRegistration pendingN2VVAir Mods And Repair Inc · Robbinsville, NJN2VYSmith William E Jr · Havre De Grace, MDN2VZUrbizu Carlos A · Tampa, FLN2WSeldom Seen Aviation Northwest Inc · Stevensville, MTN2WBPaquette Daniel · Lake City, MIN2WDBrantley Scott R · Great Bend, KSN2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEN2WTJohnson Michael A · Winter Park, CON2XCMiller Virgil J · Milton Freewater, ORN2XDPittsburgh Institute Of Aeronautics · West Mifflin, PAN2XFN2xf LLC · Windermere, FLN2XGFrisch John W III · Chicago, ILN2XHAmericas Best Amt Inc · Goodyear, AZN2XNDudebuddy Aviation LLC · Kalispell, MTN2XSCarter Delton W · Montgomery, TXN2XXTyler James · Oklahoma City, OKN2YEAllied Moulded Products Inc · Bryan, OHN2YLStroud John · Santa Fe, NM
Back to AD 2007-04-19 R1