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.
N62MHUgly Dog Aviation LLC · Lewes, DEN62PKRegistration Pending · Lillington, NCRegistration pending, canceledN62PLTjwg Inc · Grandville, MIN62SK55x LLC · Kalispell, MTN62TFLinares Rafael · Palatine, ILN62TJTb Whiskey LLC · Loveland, CON62VXDunham Darin T · Meridianville, ALN62VYVjet LLC · Bend, ORN6300PSchrempp Aviation LLC · Winnemucca, NVN6301XRonald A Peterson Inc DBA · Orlando, FLN6303BUpper Valley Aero LLC · Hanover, NHN6303XNelson Stephen C · Niwot, CON6304UHutt Aviation Inc · Minden, NVN6304XAndriopulos Salguero Inc · Hialeah, FLN6305XMurray Co · Compton, CAN6306CLongs Air Conditioning Inc · Avon Park, FLN6308HAmerican Aviation Inc · Page, AZN630CDDanoair LLC · Easton, MDN630CPRed Aviation LLC · Kalispell, MTN630CRM&A Rental LLC · Deatsville, ALN630JC15er Aero LLC · Lincoln, NEN630MDDeh Inc · Topeka, KSN630PLSaratoga Homes Of Texas San Antonio LLC · El Paso, TXN630RAAb & D Custom Furniture Inc · Monee, ILN630RCLee Aviation Services Co LLC · Pensacola, FLN6311XMatts Cats LLC · Osceola, WIN6314CC4p LLC · Jackson, TNFirst renewal noticeN6314DSaghafi Jamsheed Trustee · Parma, OHN6316XLear Traase Kj · Roundup, MTN6319XWilliver Troy Lyn · Sherwood, ORN631APCmg Aviation LLC · Durango, CON631BRBrady Risk Holdings LLC · Farmingdale, NYN631JMNewton Air LLC · Suwanee, GAN631RJBusiness Flyers LLC · Bedford, MAN631SAN631sa LLC · Wellington, FLN631SRBranch Leasing LLC · Paris, TNN631TADiamond R Aviation LLC · Canyon, TXN6320PSims Jacob Trustee · Montrose, CON6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDN6328PSabath Kenneth J Trustee · Powell, WYN6328YKoehn Lacey · Van Horn, TXN6329CUnited Indian Mission DBA · Tucson, AZN6329YDiablo Aviation LLC · Pleasanton, CAN632CDBirch Run Aviation LLC · Wayne, PAN632HGValiair Limited Co Trustee · Casper, WYN632SRowe Paul J · Fairport, NYN632UBWeigand James F · Auburn, MEN6336UBravo Whiskey LLC · Missoula, MTN6339CBowles Donald E Jr · Dallas, TXN633CDPolaris Fire Protection Inc · Port Charlotte, FL
Back to AD 2012-10-13