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.
N40679Skipper Consulting LLC · Athens, ALN4067DBlackwood William C · Irvington, ALN4067PAircraft Guaranty Corp Trustee · Oklahoma City, OKN4067ZBenninger Timothy A · Cobleskill, NYN4068NThomas Averett V · Greensboro, NCN4068XCaldwell Timothy · Spencer, WVN4068YPatkotak Hugh G · Anchorage, AKN40697Freiberg Industries Inc · State Center, IAN4069NGrady Kevin M · Spokane, WAN4069XRegistered aircraftN4069ZS&P Aviation LLC · Albuquerque, NMN406AArcher Aircraft LLC · Wilmington, DEN406ACLequire Paul D · Kingston, TNN406AFN406af LLC · Fort Pierce, FLN406AHInternational Air Services Inc Trustee · Carson City, NVN406AKPratt Benjamin C · Galena, AKN406BKN406bk LLC · Nantucket, MAN406CConstantine Jeffrey C · Charlotte, NCN406CVCivil Air Patrol · Maxwell Afb, ALN406CWMcphillips Flying Service DBA · Charlevoix, MIN406DLNon-Stop Enterprises LLC · Canoga Park, CAN406DPWings & Blades LLC · Columbia Falls, MTN406DRKent Keith M · Ellijay, GAN406DSDelaware State University · Dover, DEN406EPChristiansen Aviation LLC · Wilmington, DEN406FAStratus Rr LLC · New Castle, DEN406FDFitzsimons Raymond J III · West Bloomfield, MIN406GAHyannis Air Service Inc · Hyannis, MAN406GGCedar Creek Corp · Red Bluff, CAN406HLHelicopter Logging LLC · Lagrange, OHN406JKKolstad Jon C · Glasgow, MTN406JMMatlock Jimmy R · Granbury, TXN406LDeanda Jerrold J · Ventura, CAN406MACti Aircraft Leasing LLC · Memphis, TNN406MHJuliet Yankee Aviation LLC · Greenwich, CTN406NWJohnson Aeronautics LLC · Billings, MTN406PASale Reported · Rantoul, KSSale reported, canceledN406PGShumacker James N · Carmel, INN406PTMurray John J · Kalispell, MTN406RBAirflair Inc · Maurice, IAN406RCIsland Flights Inc · Wilmington, DEN406RJSkywest Aviation Inc Trustee · Albuquerque, NMN406RVDe Man Cameron · Bend, ORN406SLRhett Howard · Amherst, MAN406TLevel Wings LLC · Jefferson City, MON406TAAircraft Unlimited Inc · Pierre, SDN406TPGates Robert R · Helena, MTN406TWT C Willis LLC · Three Forks, MTN406VCVercruyssen Max · Honolulu, HIN406WCCebulski Wade E · Seeley Lake, MT
Back to AD 2007-04-19 R1