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.
N972SBTmacc Aviation LLC · Mooresville, INN972SDSooner Sky Aviation LLC · Edmond, OKN972TBLotane Troy Randall · Marathon, FLN973CDByrd Jack P · Cleveland, TNN973KP898 Air LLC · Indianapolis, INN973PCTennessee Beach Boyz LLC · Soddy Daisy, TNN973SThompson Peter L · Portales, NMN973SDCloud9 Aviation LLC · Wilmette, ILN973SNWiggins Hydroplanes LLC · Rainbow City, ALN97435Wipaire Inc · South Saint Paul, MNN9746YAircraft Holding Solutions LLC Trustee · Newark, DEN9748ZKerr Kenneth E · Bakersfield, CAN974DJNylund Enterprises LLC · Castle Rock, CON974KSOscar Castrejon Md LLC · Las Cruces, NMN974RCRafael Cisneros LLC · Wilmington, DEN974SRFishes And Loaves LLC · Helena, MTN974WFVictory Aviation LLC · Winchester, VAN975CWMarvphanie Equipment LLC · Byron, GAN975MCChristopher Michael W · Nicholasville, KYN975MSSherrett Ryan John · Lake Havasu City, AZN975NEEliseian Lee Trustee · Reno, NVN975PWBecker Equipment LLC · Omaha, NEN975RAGo-Fly Productions LLC · Avondale, PAN975TCConstruct Air LLC · Osage Beach, MON976ATCloud Server II LLC · Montgomery, ALN976CJValiair Limited Co Trustee · Casper, WYN976JBClydesdale Aviation Holdings LLC · Thousand Oaks, CAN976JWWe...Goose LLC · Mukilteo, WAN976TMCoast To Coast Holdings LLC · Kalispell, MTN9770CAnderson James M III · Atlanta, GAN9770MStr Holdings LLC · Lafayette, INN977CMAircraft Guaranty Corp Trustee · Oklahoma City, OKN977CPAirborne Properties LLC · Wilmington, DEN977ERAquila Management Solutions LLC · Miami, FLN977SRMedrosillo Pllc · Spring, TXN978CBMgb Aviation LLC · Morristown, TNN978GKFox Whiskey Inc · Wilmington, DEN978NSAircraft Trustee Services Inc Trustee · Dover, DEN978SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN979SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN97AHKw Air LLC · Fallbrook, CAN97BKA&D Machinery LLC · Hartsville, SCN97CKBlue Hornet Air LLC · Miami, FLN97CTBarj Associates Co · Naples, FLN97DFFlying G Aviation LLC · Elizabeth, CON97DWWestphal Dana L · Broussard, LAN97EKern County Sheriffs Department · Bakersfield, CAN97GVCirrus Design Corp · Duluth, MNN97GWLeft Coast Transport LLC · Largo, FLN97HCAlpha Whiskey 1 LLC · Brandon, MS
Back to AD 2012-10-13