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.
N3417RN3417r LLC · Wichita, KSN3417UHubnik Andrew T · College Station, TXN3417XRobbins Brian C · Meridian, IDN3417YRice Kenneth J · Moccasin, MTN3418Osterbuhr Kas · Garden City, KSN3418GOppermann William A · Derby, KSN3418SSaxton Elton P · Oklahoma City, OKN3418UHyer Randall N · Doylestown, PAN34191Cliff Air LLC · Canandaigua, NYN34193Hurley William James III · Abingdon, ILN34197Sellars Kenneth · Loudon, TNN3419FSchreib John D · East Troy, WIN3419JBlackhawk Air LLC · La Porte City, IAN3419RMcnutt Dava M · Port Angeles, WAN3419USpanos Richard P · Brooksville, FLN3419XBrown Jarrod · Beaumont, TXN3419ZVintage Piper LLC · Lexington, KYN341AKGoddard Gary · Ohkay Owingeh, NMN341ATKlodd Stephen · Granbury, TXN341BCAbeflies LLC · Montvale, NJN341BGAttack Jack Enterprises LLC · Wilmington, DEN341CBreaking Wind Aviation LLC · Brainerd, MNN341CCContinental Helicopters Inc · Sheffield, TXN341CHAce Flight Center Inc · St Thomas, VIN341CMBc Aviation · Perham, MNN341CPCivil Air Patrol · Maxwell Afb, ALN341DCKiener Matthew J · Pottersville, NJN341DREcho Sierra Inc · Potomac Falls, VAN341ECPiper Aircraft Inc · Vero Beach, FLN341FAJb Aircraft LLC · Anchorage, AKN341FCCondor Aero Club Inc · Zelienople, PAN341FTWatkins Robert W II · Parsons, TNN341HCStc Aviation Inc · Saint Cloud, MNN341JCCopeland David Craig · Jackson, GAN341JPRed Arrow Leasing Inc · Paw Paw, MIN341LHBravo Gildaro F · Mcallen, TXN341MKAlba Aviation Services Inc · Scottsdale, AZN341MTI2i Logistics LLC · Wheeling, ILN341NDUnd Aerospace Foundation · Grand Forks, NDN341PBPpb Aviation Management · Wading River, NYN341PCWoods Ronnie Lee · Weatherford, TXN341PSWestern States Air LLC · Phoenix, AZN341RAYang Chi · Lafayette, CON341RVNelson Flyers Inc · Louise, TXN341SCShedd Aviation LLC · Columbus, INN341SJAga Aviation LLC · Lewes, DEN341SLMartin David V · California, KYN341SPSo Cal Leasing LLC · El Cajon, CAN341STZimmie Thomas F · Wynantskill, NYN341TAUnited States Of America · Travis Afb, CA
Back to AD 2007-04-19 R1