AD 2023-02-13
Registered aircraft · 255
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:2023-02-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:2023-02-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:2023-02-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:2023-02-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.
N304KSonic Automotive Inc · Charlotte, NCN30HQLearjet Inc · Wichita, KSN311KBJet Plaid LLC · Nashville, TNN312SHRegistered aircraftN313JLJnl Equipment Leasing LLC · Camden, DEN313STIota Aviation LLC · Bloomfield Hills, MIN317MLMds Falcon LLC · Kittanning, PAN321AJM Hixson Aviation LLC · Denton, TXN321AKSnails Pace Aviation LLC · New York, NYN322FJRegistered aircraftN324SLAp Aviation LLC · Troy, VAN356LGRegistered aircraftN35KVMit Oregon LLC · Portland, ORN361DDWeco West LLC · Catarina, TXN3712CF900ex LLC · Minneapolis, MNN373RSKalamazoo Group II LLC · Kalamazoo, MIN382KUMaverick Aire LLC · New Castle, CON387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN39NPWilmington Trust Co Trustee · Wilmington, DEN400THDuke Vacation LLC · Wilmington, DEN401GJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404FWcf Aircraft LLC · Detroit, MIN405EKArlington Aircraft Of Nevada LLC · Sun Lakes, AZN40LBFirst Premier Corp · Sioux Falls, SDN412ECBank Of Utah Trustee · Salt Lake City, UTN416KCSpenaero Lc · Salt Lake City, UTN41MBRivers Equipment LLC · Nashville, TNN420PDKms Air LLC · West Bend, WIN424UAeronavis LLC · Wilmington, DEN425RJFant Aircraft Enterprises LLC · Houston, TXN428DRMaverick Air II LLC · Deer Park, WAN42NFCest La Vie LLC · Piedmont, OKN440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN44VPGable S Corp · West Linn, ORN469SSDeez-Nuts LLC · Goodlettsville, TNN46RBaci LLC · Portland, ORN47EGWing And Rotor Transportation Holdings LLC · Morristown, NJN488MHSmyrna Ready Mix Concrete LLC · Nashville, TNN48CGCorning Inc · Corning, NYN493CFShamrock Air LLC · Baltimore, MDN499MHHollingshead Aviation Services LLC · Murfreesboro, TNN4DFCds Equipment LLC · Cincinnati, OHN4SM4sm LLC · West Palm Beach, FLN4TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN500BLBnb LLC · Wilmington, DEN500JJUltimate Human Aviation LLC · Coconut Grove, FLN50LBRegistered aircraftN510HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN510RHHms Holdings LLC · Charlotte, NCN512KSMcreynolds Aviation LLC · Dallas, TX
Back to AD 2023-02-13