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.
N432RADirect Entry Holdings LLC · Port Richey, FLN4331ECmb Holdings LLC · Logansport, INN43362Plane Fun Inc Tr Trustee · Snellville, GAN43368Triple 4 Aviation LLC · Martindale, TXN433ALBowline Aviation LLC · Jupiter, FLN433BPLeverock Richard C · Port Saint Lucie, FLN433CAJaxcor LLC · Temecula, CAN433CFRotormate LLC · Royse City, TXN433CPPaul Family Properties - Texas LLC · Wasco, CAN433MLMca Inflight LLC · Summerdale, ALN433TMChristensen Michael S · Mesa, AZN43412Registered aircraftN4341NGg And Sg Properties LLC · Seminole, FLN434BRRoberts Aviation LLC · Myrtle Beach, SCN434CCLambo Air LLC · Springtown, TXN434CDFlycarolina LLC · Concord, NCN434DKOshaughnessy Terrence · Boulder City, NVN434JGGordon Adam Leo · Oakdale, LAN434KBConnecting Aviators LLC · Katy, TXN434MMMlc Aviation LLC · Inver Grove, MNN434SRMiller Richard Francis · Waxhaw, NCN434TBFlightworks LLC · Crozet, VAN434TX22t-11239 LLC · Austin, TXN4358MKimt LLC · Iron Mountain, MIN435CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN435CPNext Century Aviation LLC · Boca Raton, FLN435JAJorgensen Aviation Inc · Richfield, UTN435MGonzalez Frank · Sun Valley, CAN435SRM2 Aviation LLC · Concord Township, OHN435TXBorah Peak LLC · Austin, TXN435WPPinpoint Locating Inc · Ashville, ALN4360VMb Powers Inc · Thompsons Station, TNN4363LVeritas Holdings LLC · Washington, DCN4363MArk 84 LLC · Wilmington, DEN4366ZEse Aviation LLC · Houston, TXN436CDSky West Aviation Inc Trustee · Albuquerque, NMN436CPAeronauncents LLC · El Paso, TXN436MHaase LLC Series 5 · Henderson, NVN436RADebon Corp · La Center, WAN4372BTyler Hendry Dds Inc · Glendale, CAN4372EPad Aviation LLC · New Castle, DEN4372LSteen Douglas S · Cresson, TXN4376APeavy Ricky Tod · Gainesville, GAN4377ATebeaux William Jene · College Station, TXN437CWestacott Simon · Fenwick Island, DEN437KMAce Holdings LLC · Sioux Falls, SDN437RPPastusek Robert R · Granbury, TXN4380DLivengood Leasing Co LLC · Mesa, AZN4380S9791m LLC · Tacoma, WAN4386NFreedom Airplane Jv 1 LLC · Pensacola, FL
Back to AD 2012-10-13