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.
N2960DRed Baron Rentals LLC · Jacksonville, FLN2960PBrown Daniel A · Gettysburg, PAN2960RVarun 2016 LLC · Florence, SCN2960WDawson Ben J · Milton Freewater, ORN2960YHudson Maury B · Humble, TXN2961Wilbanks Kevin W · Artesia, NMN29610Ammar Elias G · Colton, CAN29617Abbott Barry · Tempe, AZN29619Loudenslager Donald F · Collinsville, OKN2961AMerrill Richard C · Chuckey, TNN2961BHyldburg Aviation · Plymouth, MAN2961FNilssen Carl J · Cameron, WIN2961JFrey Jerry P · Fallon, NVN2961PRegistered aircraftN2961TMagnumforamen Ppg Aeroadventures LLC · Kalispell, MTN2961WKrauss Solutions LLC · Debary, FLN2961XLaurina Peter · Knoxville, TNN2961YGarcia Kale B · Covington, WAN29625Sale Reported · Fort Myers, FLSale reportedN2962AKapsner Mark W · Willow, AKN2962EPaulisue Aviation LLC · East Saint Louis, ILN2962FMcclevey Landon Kole · Dilley, TXN2962LAllen Marcus I · Little Elm, TXN2962RHurn Enterpises LLC · Grand Beach, MIN2962TAviation Days LLC · Ridgefield, CTN2962UFlake Philip · Pearland, TXN2962XRomine John M · Broken Arrow, OKN2962ZMull Jason E · Chester, NYN29631Registered aircraftN29638Seal Seismic Service LLC · Oklahoma City, OKN2963CMcmillian Tommy D · Wasilla, AKN2963FConnell Gary A · Anchorage, AKN2963XWayner Ronald P · Sutton, AKN2963YMoretti Larry · Monroe, MIN29643Campbell Robert A · Dayton, TXN29645Borgman Dale A · Rescue, CAN2964CBrown A Russell · Lafayette, TNN2964DKluge Kris D · Mound, MNN2964FHunt Stuart J · Lynn Haven, FLN2964TMallard Aviation LLC · Manchester, NHN2964YVanderwel Paul · Woodinville, WAN29651Geurs John Z · Ossian, INN2965APa 32 LLC · Union Center, WIN2965CBauer Joachim · Rhome, TXFirst renewal noticeN2965FFrank Paul R · Waukesha, WIN2965WFly On LLC · Boise, IDN2965XLynch Thomas L · Fort Collins, CON29664Tyree William B · Arlington, TXN29667Viles Timothy · Bartlett, TNN2966ACroffut David P · Anchorage, AK
Back to AD 2007-04-19 R1