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.
N575LPWildkat Aviation LLC · Hudson, OHN575MCStuteville Consulting LLC · Durant, OKN575PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN575SABarnts Sales Company LLC · Diller, NEN575SWHester Thomas F · Santa Barbara, CAN575TVIssue V Inc · Huntington Beach, CAN575TXHu Jianing · Santa Clara, CAN575WTDanemann Mark · Taos, NMN575XSnowy Owl Investments LLC · Scottsdale, AZN5762JJonesco Acquisitions LLC · Bixby, OKN5763MStan Hill Aviation LLC · Waterford, MIN5765MBush Abe A · Eatonton, GAN5768S3c LLC · Waukee, IAN576BSC&J Aerobiz LLC · Madison, ALN576CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN576CPQualitair LLC Trustee · MichelstadtN576DGEdge David Lee · Lumberton, NCN576NMKlas-Kcoe LLC · Las Vegas, NVN576TMCadence Truck And Trailer Leasing LLC · Chicago, ILN577DGW&E Aviation LLC · Peoria, AZN577DHHawkeye Aviation LLC · Mason, OHN577HSAircraft Guaranty Corp Trustee · Oklahoma City, OKN577KBDavid A Bush Inc · Hanford, CAN577SRSteubesand Karl · Rhinebeck, NYN5785CNoonan Leasing LLC · Johnstown, NYN578AGAlpha Gulf Holdings LLC · Wesley Chapel, FLN578CDCarothers Donald Luis · Bakersfield, CAN578CPOsman Keenan · Seffner, FLN578DJDrj Management LLC · Edmond, OKN578PSAircraft Guaranty Corp Trustee · Oklahoma City, OKN578SBPremier Aviation LLC · Klein, TXN5793MCoxbill Farms Inc · Torrington, WYN57977Denney Dennis · New Port Richey, FLN579AGAccum Claude Alan · Dover, MAN579MWCqf Holdings LLC · Fairhope, ALN579SRShepherd Kris R · Blue Ash, OHN579TWGuerra Gerald · Sandusky, OHN57AMclallen Holdings LLC · Saint Charles, ILN57AECirrus Design Corp · Duluth, MNN57CJCj Aero LLC · Eustis, FLN57CXDmdt Ventures LLC · Victor, NYN57DB57db Aviation LLC · Fort Myers, FLN57DCPorton Qozb LLC · Mesa, AZN57DECape Aviation LLC · Lewes, DEN57DGValiair Ltd Co Trustee · Casper, WYN57DMPrecision Aviation Inc · Tulsa, OKN57FECavu Air LLC · Lees Summit, MON57FMCohen Aaron H · Chattanooga, TNN57GXJfp Aviation Inc · North Fort Myers, FLN57KZKaz Mobility LLC · Kiawah Island, SC
Back to AD 2012-10-13