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.
N8ZPDllm LLC · Chanhassen, MNN9002VMason Thomas · Lubbock, TXN9003Andreotti Mark · Colusa, CAN900AWBonanza Five Flying Club Inc · Roswell, GAN900GMKashtan David L · Mill Valley, CAN900PMDungan Aerial Service Inc · Oro Valley, AZN900SHShadowline Aviation LLC · Wilmington, DEN900TCBlanco James A · El Dorado Hills, CAN901GMMorrison Joseph M · Memphis, TNN901GTS&L Motorsports LLC · Biloxi, MSN901KDJrk Aviation LLC · Wayzata, MNN901MPeak Resolutions LLC · Menifee, CAN901MLDiamond Star Fl Properties LLC · Arcadia, OKN901PFMeliora Capital Inc · San Diego, CAN901PNWosor LLC · Nashville, TNN9026MGlenn Stephen B · Texarkana, TXN902ATAbet · Freeport, MEN902BAEcho Charlie LLC · Manvel, NDN902KDRegistration Pending · Brookfield, WIRegistration pendingN902RDSouthlake Aviation LLC · Arden, NCN902SRPlane Fun Inc Tr Trustee · Snellville, GAN902WBBelcher William · Lancaster, NYN903ATEga Three LLC · Gadsden, TNN903CAHyannis Air Service Inc DBA · Hyannis, MAN903DSMooney Bird LLC · Wilmington, DEN903RDJkj Aviation LLC · Wilmington, NCN903RMSmith Jordan · Athens, ALN9040CTexas Skyways Inc · Boerne, TXN9046FCenturion Aviation LLC · Lewes, DEN904ATBeitler Jonathan J · Camden, MEN904BLAls Aviation LLC · Jacksonville, FLN904CDTrailer Trash Management LLC · Coburg, ORN904CGAccess Consulting LLC · Edmond, OKN904JPWlcc Management LLC · College Station, TXN904LMLls LLC · Fort Wayne, INN904MMKane Alan · Pinehurst, NCN904STAir Alpes Services Corp · Wilmington, DEN905ATWagner Kendall · Yorba Linda, CAN905ETDawson Richard E · Green Valley, AZN905MAHigh Flight LLC · Casey, ILN905MJScaa Aviation LLC · Tyler, TXN905PCLamb Robert Duncan · Kiln, MSN905SECc Self Aircraft Holding LLC · Wilmington, DEN9063MThompson Anthony · Miami, FLN906CDHiggins Mechanical Inc · Gardner, MAN906RDCollareno Kevin A · Northville, MIN906WTCollaborative Horizons LLC · Bennington, NEN9079HJoey Os LLC · Darlington, PAN907CAllen Gavin Alton · Bloomfield, CTN907CDGullapalli Vamsi K · Sartell, MN
Back to AD 2012-10-13