AD 2011-15-05
Registered aircraft · 781
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:2011-15-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-15-05')
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:2011-15-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-15-05') 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.
N220CGOffshore Energy Services Inc · New Iberia, LAN220FSHonker Air LLC · Huntingburg, INN221FTTortuga Ventures LLC · Covington, LAN221GSendero Aviation Services LLC · Dublin, TXN222PVJ Turbines Inc · Wilmington, DEN225CMMcmillin Sce LLC · El Cajon, CAN227NCCausebe LLC · Black Mountain, NCN228AJTriton Airplane Leasing LLC · Wilmington, DEN22VRHot Rock LLC · Dover, DEN2316National Nuclear Security Administration · North Las Vegas, NVN2317National Nuclear Security Administration · North Las Vegas, NVN2319National Nuclear Security Administration · Las Vegas, NVN23SYVlf Air LLC · Calabasas, CAN241VVWorldwide Aviation LLC · Springfield, MON243MHAllen Contracting Inc · Oklahoma City, OKN243PBFargo Jet Center LLC · Fargo, NDN247CHShe Jane LLC · Laguna Beach, CAN247SZSheetz Aviation Inc · Altoona, PAN248EXUnited States Navy · Patuxent River, MDN250AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN250LHAl Air LLC · Knoxville, TNN251JDepartment Of Homeland Security · Washington, DCN252FLTenax Aerospace LLC · Ridgeland, MSN252HRJohnson Breeders Inc · Rose Hill, NCN255BBWright Aviation LLC · Charleston, TNN260TTTri-State Generation & Transmission Association · Westminster, CON263BACreative Life LLC · St Pete Beach, FLN268LBLark Builders · Vidalia, GAN26RFVuc Inc · Allentown, PAN2702SMdm Air LLC · Belpre, OHN275LLN275ll LLC · Wilmington, DEN276EBMountain Air Aviation LLC · Jonesville, VAN276JBChris Allen Aviation LLC · Naples, FLN277FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN277JEAir LLC · Jasper, INN278KWAir Rgv LLC · Mcallen, TXN280WDWak Aviations LLC · Green Bay, WIN283JDDurham Aircraft LLC · Port Aransas, TXN285RRio Bank · Mcallen, TXN285RBButler National Inc · New Century, KSN287ATN399bw LLC · California, MDN289ATN999mg LLC · California, MDN28BDSouthern Illinois Helicopters LLC · Marion, ILN28KAJames John · Bennett, CON28WCMoorad Sports Partners LLC · Newport Beach, CAN291ASLasai Aviation LLC · Reston, VAN292TGCrown Aviation LLC · Lawrence, KSN298CFRichmond Investments Inc · Wilmington, DEN29VSV-Jet Aircraft Holding Co Trustee · Dover, DEN2UWUniversity Of Wyoming · Laramie, WY
Back to AD 2011-15-05