AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N55RJAlamogordo Rental Company LLC · Alamogordo, NMN55RXJs Enterprises LLC · Clarinda, IAN55TNEa Aviation Inc Trustee · Wilmington, DEN55WVN728bj Aviation LLC · Barker, TXN560BBSednal Enterprises · Los Gatos, CAN560CDKlohn Volker · Houston, TXN560RGG350 Leasing LLC · Portland, ORN560SR40 And Rising Aviation LLC · Memphis, TNN561AUIflysims Aviation Inc · Las Vegas, NVN561CDGainesville Aircraft Sales Inc · Gainesville, FLN561CP3809 Kilo LLC · Wilmington, DEN561DJAir Maresca LLC · Potsdam, NYN561RTRkg Enterprises · Hibbing, MNN561SSws Air LLC · Palm Beach Gardens, FLN561SMRichbuilt Construction LLC · Fort Pierce, FLN562CDFeldman Thomas · Renton, WAN562DGB2d LLC · Wickenburg, AZN562FDCapital Aviation LLC · South Easton, MAN562GHN562gh LLC · Cleburne, TXN562MValiar Lc · Casper, WYN562SBFirst Step Aviation LLC · Charlotte, NCN562SDWarren-Williams LLC · Philadelphia, PAN562SHBravo Charlie Aviation LLC · Charlotte, NCN562YDion William · Coupeville, WAN5632Averyation LLC · Saint Louis, MON5634QLegacy Aero LLC · Jonesboro, ARN5636GTres Locos Gringos LLC · Lubbock, TXN5639ZHowman Aero LLC · Cleveland, OHN563CDEl Paso Aero Inc · El Paso, TXN563CP5teevee LLC · La Grande, ORN563DTWhitehead William C · Mills River, NCN563MMMegel Air LLC · Cleveland, GAN563PGKureishy Zaveen A · Triadelphia, WVN563RFHjc Aircraft LLC · Pleasant Valley, IAN563SMD3 Aviation LLC · Fairfield, NJN5643CAdvance LLC · Waterville, MEN564BAF A I LLC · Marianna, ARN564BPCrhrr LLC · Riverside, CAN564FDNf Aviation LLC · Newark, DEN564JHYj Aviation LLC · Blakely Island, WAN564NChadwick Aviation LLC · Boca Grande, FLN564PMKrebs Stephen P · Houston, TXN564RRAlpha Romeo Aviation LLC · Newark, DEN56539Six 27 Properties LLC · Flint, TXN5655CRegistration Pending · Westford, MARegistration pendingN5656MBuchanan Travis W · Sanford, NCN565CPBas Part Sales LLC · Greeley, CON565MJse Aviation LLC · Franklin, NHN565PAero Cruz LLC · Agoura Hills, CAN565RAN565ra LLC · Elbert, CO
Back to AD 2012-10-13