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.
N508FGRidgeline Assets LLC · Wilmington, DEN508GLCirone James · Pampa, TXN508HSBlue Chase LLC · Wilmington, DEN508NDCorsair Aviation LLC · Pacoima, CAN508RFFugate Richard Dee · Rochester, MNN508SDPate Charles C Trustee · Wichita, KSN508TCFisher Travis L · Odessa, TXN508THFowler David P · Freeport, MEN508VStahl Victor A · Houston, TXN508XCHirst Jeremy · Solana Beach, CAN50901United Indian Missions Inc DBA · Tucson, AZN50906Aitken & Wilson Aviation LLC · Leesburg, VAN5090EMelbourne Flight Training LLC · Melbourne, FLN5090MAri Ben Aviator Inc · Fort Pierce, FLN5090RStahla Russell A · Girdwood, AKN5090SSturm Neal M · Randolph, NJN5090TWoodcox Edmund A · West Monroe, NYN5090UVolatile Aero Ventures LLC · Boulder City, NVN5090WJaybird Aviation LLC · San Antonio, TXN5091717 Leasing LLC · Englewood, CON5091CMartin Steven J · Phoenix, AZN5091DKuhn Chad · Boulder, WYN5091EAmerican Asset Leasing LLC · Aurora, ORN5091PSpicuzza Robert A · Waterford, MIN5091SLancellotti Peter · Knoxville, TNN5091TBlank Philip J · Pleasanton, CAN5091VWilliams Timothy J · Fernandina Beach, FLN5091WRegistration Pending · Anchorage, AKRegistration pendingN50924Robinson Mark V · Vacaville, CAN50926Registered aircraftN5092EKaye Russell G · New Fairfield, CTN5092MZavalney Steven Michael · Canyon, TXN5092NMill-Run LLC · Lewes, DEN5092TZigo Daniel N · Madill, OKN50935Civil Air Patrol Inc · Maxwell Afb, ALN50937Tls Aviation LLC · Eldridge, IAN50939Heart X Aviation LLC · Salmon, IDN5093EBohmer Carla M · Tulsa, OKN5093FRedick Albert L II · Reno, NVN5093KL A M Capital Management LLC · Sheridan, WYN5093PAir Chutney LLC · Waynesboro, VAN5093RSkyhawks Inc · Montoursville, PAN5093SPerez Matthew C · Indianapolis, INN5093TTaylor Allen S · Oak Harbor, WAN50941Labrucherie Peter E · El Centro, CAN50944Munoz Jacqueline T · Huntsville, ALN50947Bend Aircraft Mechanics LLC · Bend, ORN5094RHigh View Air LLC · Driftwood, TXN5094SBoraam Aviation Inc · Prospect Heights, ILN5094TKrass Roman · West Hills, CA
Back to AD 2007-04-19 R1