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.
N5621XDiorio Joseph · Murrieta, CAN5621ZJon Air LLC · Dover, DEN56220Seashell Aviation LLC · Milton, FLN56224Thomas Way LLC · Jackson, MIN56227Registration Pending · Ira, MIRegistration pendingN5622ECivil Air Patrol Inc · Maxwell Afb, ALN5622KAyorinde Olawale T · Upper Marlboro, MDN5622PBaker Franklin E · Montgomery, ILN56231Leber Oliver P · Spanish Fort, ALN56239Hobart Aviation Inc · Akron, OHN5623EKd3262 LLC · Downers Grove, ILN5623GMorris Hancock Flying Club · Morris, MNN5623KLyell Danny P · Ridgeway, SCN5623UMendoza Cesar · Anthony, NMN56241Smith Bonny L · Milan, INN56247Aviair Corp · Tequesta, FLN5624GFoothill Aircraft Sales & Service · Upland, CAN5624KWilson Robert J Jr · Gaithersburg, MDN5624PCobb Jeremiah B · Colorado Springs, CON5624QSwanson Shawn · South Beloit, ILN5624SKin-Air Inc · Hendersonville, TNFirst renewal noticeN56256Flying Bears Aviation LLC · Wilmington, DEN5625KChung Thomas · Stanwood, WAN5625QFly High Aviation LLC · Margate City, NJN5625USkorina Air LLC · Walla Walla, WAN56264Fingerlakes Aviation LLC · Marietta, NYN5626LMw Aviators LLC · Olathe, KSN5626UFly Around Alaska LLC · Palmer, AKN5626WMiller Andy · Marana, AZN56277Lightfoot John A · Hagerstown, MDN5627BTaylor Tona R · Graham, WAN5627FFolger Alfred J · Columbia, SCN5627KTaxman Aviation Training Inc · Port Orange, FLN5627UMcelhannon Susan L · Athens, GAN5627WSavio Stefan V · Trophy Club, TXN56280Briggs Samuel K · Portland, ORN56281Lewis Nathan Timothy · Hayden, IDN56282Kowatra Anil K · Lilburn, GAN56283Stephens Donald K · Modesto, CAN56286Rigoni Terry N · Prescott, AZN56288Cole Douglas W · Kennewick, WAN56289Butler Stephen P · Ossian, INN5628FHobbs Jason · Saint Francisville, LAN5628JAviate 208 LLC · Oconomowoc, WIN5628LRegistered aircraftN5628PMiller Space A · Simi Valley, CAN5628SSchrier Timothy · Savage, MNN5628WB & D Aviators LLC · Bremen, INN56290Franscioni Farms Inc · Salinas, CAN56291Mccall Albert B II · Lebanon, TN
Back to AD 2007-04-19 R1