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.
N537LBHttrr LLC · Austin, TXN537SWBingham Leasing Co Lc · Mesa, AZN537VBruno Airways LLC · Fayetteville, GAN5383ASummers Timothy P · Rincon, GAN5384WFlitemax Inc · Redondo Beach, CAN5386ATriplett And Adams Transport Partnership LLC · New Concord, OHN538CDBertain Paul · Davis, CAN538NPolk Equipment Inc · Leesburg, INN538SRRegistered aircraftN538SYJre Management Services LLC · Ashland, VAN5391ASingh Amandeep · Stockton, CAN5394XL K Hollenbeak Logging Inc · Hayfork, CAN5395VCortez Flying Service Inc · Cortez, CON539CDAltmann Michael · Folsom, CAN539FDCirrus Design Corp · Duluth, MNN539MHHolten Michael H Trustee · Maryville, ILN539SRRoe Robert Darrell · Georgetown, INN53AUJoachim Peter · Grafton, WIN53CKJace Viate LLC · Tempe, AZN53CRJms Transportation LLC · Leesville, LAN53CWBeitel Theodore C · Higden, ARN53DHHighgate Aero Inc · Swanton, VTN53KH53kwd LLC · Mason, TXN53LGDominion Ventures Inc · Wilmington, DEN53SHJames Robinson Homes LLC · Alpharetta, GAN53WMBurns Ivan · Concord, MAN53WTRock House LLC · Keizer, ORN5401AHeadon Richard · Chino Hills, CAN5401XBarbera Frank M · Edgewood, NMN5404WBas Part Sales LLC · Greeley, CON5405AN5405a LLC · Beverly Hills, CAN5409GRichland Aviation Inc · Sidney, MTN5409YLee Christopher · Katy, TXN540CEEverel Airborne LLC · Sandia Park, NMN540NEAirswiss Inc · Wilmington, DEN54105Gopub Aviation Inc Trustee · Wilmington, DEN5411Mpfa Holdings LLC · Hot Springs, ARN5416UU S Department Of Agriculture · College Station, TXN5416YKer Holdings LLC · Henderson, NVN54175Aircraft Guaranty Corp Trustee · Oklahoma City, OKN5417YFeldner Mark A · Schererville, INN5419WKenosha Aviation LLC · Jacksonville, FLN541BN907 Aviation LLC · Bend, ORN541CDAcheson Wiliam B · Waconia, MNN541CMAero Parts LLC · Roselle, ILN541DFSr20 Holdings LLC · Coral Springs, FLN541JDBlue Sky Flyers LLC · Hoover, ALN541SRSierom LLC · Charlotte, NCN541SWSchoorl John H · Quartz Hill, CAN541VRStarling Investors LLC · Henderson, NV
Back to AD 2012-10-13