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.
N510JESoul Adventure LLC · Edwards, CON510LGTvpx Ars Inc Trustee · North Salt Lake, UTN510NEAirswiss Inc · Wilmington, DEN510TFLang Eric O · Oklahoma City, OKN510TXAircraft Tanks LLC · Camden, DEN510WFFuel Center Plus Inc · Silver City, NMN5111JValiair Ltd Co Trustee · Casper, WYN511AAValiair Lc Trustee · Casper, WYN511ATCirrus Design Corp · Knoxville, TNN511BJohnson Brian P · Baileys Harbor, WIN511CMartin Gary N · Lake Jackson, TXN511CDTailwinds Aviation LLC · New Orleans, LAN511CTGlen Lake Management LLC · Bradenton, FLN511JTJuliet Tango Aviation LLC · Athens, GAN511JWCavu Air LLC · Edmond, OKN511RLHatch Leasing Co LLC · Marble Canyon, AZN511RMOlivia Aviation LLC · Denver, CON511SEBaehr Michael C · Hernando Beach, FLN511SKRegistration Pending · The Woodlands, TXRegistration pendingN511SRHunter John D · Alamo, CAN511TBEncore Systems Group LLC · Cleveland, OHN511TRPark Place Aviation Management Company LLC · Kirtland, OHN511WYPeak Air LLC · Birmingham, MIN5122QPyxis LLC · Cheyenne, WYN51237Infanger James Robert · Salmon, IDN5123YDillon William · Corvallis, ORN5124WBest Life Aviation LLC · Cedar Park, TXN5127QRegistered aircraftN5128CLacey Nora B Trustee · Incline Village, NVN512APArcrft Sr2x LLC · Ashburn, VAN512AWAir Ware Leasing LLC · Austin, TXN512CDRns Management Holdings LLC · Naples, FLN512CPCore Aviation LLC · Dayton, OHN512GTBarron Thomas Aviation Inc · Scottsdale, AZN512HJN512hj LLC · Miami, FLN512HPN512hp LLC · Dover, DEN512HWKd Aviation LLC · Palo Alto, CAN512KZotec Partners LLC · Carmel, INN512KPKaweah Pump Inc · Visalia, CAN512LTJd Aviation Ventures LLC · Miami, FLN512MCMccourt Aviation Group Inc · La Grange, TXN512MDCitadel Blue LLC · Gainesville, GAN512PELongaro Joseph · Austin, TXN512RDRm Air LLC · Columbus, OHN512SBN512sb LLC · Austin, TXN512SLSalmon Raymond A Trustee · Tavares, FLN512TAArbogast N512lt LLC · Austin, TXN512TRFox And James Inc · Latrobe, PAN512TTTango 2.0 LLC · Austin, TXN512TWDelaware Aircraft Trust LLC Trustee · New Castle, DE
Back to AD 2012-10-13