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.
N3775FHickle William H · Inyokern, CAN3775PClayton Patrick D · Hazen, ARN3775RBack Mark D · Washington, DCN3776USchmit Joe · Ventura, IAN3776XSkyline Aircraft Maintenance Inc · Nampa, IDN3777DOrchid Aero LLC · Lakewood, CON3777LCowboy Aviation Services LLC · Polson, MTN3777PSkatvold Charles P · Moorhead, MNN3777SStuart Guy · Owosso, MIN3777TStewart Donald J · Palm City, FLN3777ZAnderson Clarence Trustee · Anchorage, AKN3778DBrownd Carl L · Oro Valley, AZN3778TVan De Vanter Robert A · Paso Robles, CAN3778UBlue Goose Aviation Inc · Polson, MTN3778XChang Tim C · Ocala, FLFirst renewal noticeN3778YTime Air LLC · Mendon, UTN3778ZWard Nelson H · Salcha, AKN37790Cottrell Mark C · Leitchfield, KYN3779DSeattle Glider Council Inc · Bellevue, WAN3779NObrien Edward Trustee · Walnut Creek, CAN3779QLegge John D · Cleveland, OHN3779TShultz Martin · Naperville, ILN3779UWhittom Ronald W Jr · Wasilla, AKN3779WAirmotive Service LLC · Brigham City, UTN3779YJoiner Matthew A · Temple, GAN3779ZNace Kris A · Glendale, ORN377AMJohnstone Inc · Wilsonville, ORN377BFountain Acquisitions LLC · Mount Vernon, GAN377BMQuebec Helicopter LLC · Rehoboth Beach, DEN377CACivil Air Patrol · Maxwell Afb, ALN377CBBradley Charles A · Gibsonia, PAN377CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN377CEMetal Mistress Aviation LLC · Meadowview, VAN377CFCohen Rolando S · New York, NYN377CPHodgson Jeffrey R · Watsonville, CAFirst renewal noticeN377CZKramer Dean E · Bernville, PAN377DShawn Wyatt Enterprises Inc · Huntsville, TXN377DSSeward Bernard L Jr · Charlottesville, VAN377EBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN377ESEastern Cincinnati Aviation Inc · Batavia, OHN377GGemini Southern LLC · Orlando, FLN377HGHunt James J · Dalton, PAN377HHJennings Christopher Wyckoff Trustee · Brentwood, TNN377JDStyer David · Milton Freewater, ORN377JS270 Aviation LLC · Elizabethtown, KYN377KCEagle Flying Club LLC · Enid, OKN377KGGardetto Paul R · Oconomowoc, WIN377LLLawson Larry · Palmer, AKN377LMOliver Gerald D III · Midlothian, TXN377RCAncona Air LLC · Wixom, MI
Back to AD 2007-04-19 R1