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.
N313NRDawn Patrol LLC · Portsmouth, NHN313RWSarp Rentals LLC · Loudon, TNN313SCCirrus N7580 LLC · Valparaiso, INN313SRTrust Your Fronts LLC · Miami, OKN313TF313tf Aviation LLC · Superior, WIN313TLSmallwood Aviation LLC · Nokesville, VAN313VBVernor Air LLC · Harbor Springs, MIN313VFRegistered aircraftN313WTCinotto Robert L · Rhome, TXN31416Pterosaur Holdings LLC · Scarsdale, NYN3144YSierra Bravo Zulu LLC · Middletown, DEN3147LBrowning Charles H III · Woodbine, MDN3148PSky Hi Aviation LLC · Wilmington, DEN314AAlien Air LLC · Missoula, MTN314CPWilbury LLC · Las Vegas, NVN314DGLaminar Holdings LLC · Sheridan, WYN314DSFlyers Unlimited LLC · Tucson, AZN314HBMarc Inc · Bolton, MSN314KD314 Aviation LLC · Carlisle, PAN314KFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN314PKKelsey Excavating Inc · Davis, ILN3151JStava Robert D · Brainard, NEN31526Trostel Manfred E · Longboat Key, FLN3152ERegional Medical Consulting Pllc · Mebane, NCN3153BSeverson James A Jr · Tualatin, ORN3153PWhiskey Mike Aviation LLC · Merrimac, WIN3154FMetcalf Management Inc · St George, UTN3156XBack Country Aviation LLC · Jupiter, FLN315AHHorizon Aviation Holdings LLC · Fort Lauderdale, FLN315CACirrus Middle East Inc Trustee · Wilmington, DEN315CDFranklin Clinton · Edmond, OKN315CEAddonizio Victor Paul III · Long Island City, NYN315CKMarket-Partners Inc · Santa Rosa, CAN315DBBooker Daniel R · Newaygo, MIN315GTN315gt LLC · Naperville, ILN315JRStarkweather James · Southwest Ranches, FLN315JSAmore Industries LLC · Greer, SCN315MCDeeds Brian A · Meridian, IDN315NLBestrand Aviation LLC · Cincinnati, OHN315PZPizzo Philip · West Sacramento, CAN315RTTidwell Consulting LLC · Phil Campbell, ALN315SRMarciniak Paul D · Lebanon, TNN315TARegistered aircraftN315VGValiair Limited Co · Casper, WYN315XRegistered aircraftN3160LKo Hee Sun · Norwood, NJN31644Aquarius Aviation Inc · Miami, FLN316ABRegistered aircraftN316BCBc Air LLC · Great Falls, VAN316BW345ds Capital Holdings LLC · Scottsdale, AZ
Back to AD 2012-10-13