AD 2025-05-13
Registered aircraft · 630
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:2025-05-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:2025-05-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:2025-05-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:2025-05-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.
N233FXFlexjet LLC · Cleveland, OHN234FXFlexjet LLC · Cleveland, OHN235EETcn Transport 300 LLC · Dallas, TXN235FXFlexjet LLC · Cleveland, OHN235WVBank Of Utah Trustee · Salt Lake City, UTN237JTShady Grove Road Investments LLC · Brookhaven, GAN23EEAlbin David R · Sante Fe, NMN242LLStormjet LLC · Flowood, MSN243SLCsc Delaware Trust Co Trustee · Wilmington, DEN244LGMeridian Partners LLC · Wilmington, DEN247CMRaridon & Associates Orthopedics Inc · Clive, IAN247JKSelectransportation Resources LLC · Houston, TXN247KATropacaval Media LLC · Victoria, TXN247WPPlane Alpha LLC · New York, NYN24PLPolaris Industries Inc · Medina, MNN250ALTrs Transportation Inc · Columbia, ILN250GBGolding Barge Line Inc · Vicksburg, MSN252AGAndon Marketing · Los Angeles, CAN254MSAggie Aviation LLC · Buna, TXN254TXTrandmedics Inc · Belgrade, MTN256LGLima Golf LLC · South Burlington, VTN25FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN25HFHaidar Aviation LLC · Dallas, TXN261TXTransmedics Inc · Belgrade, MTN263TXTransmedics Inc · Belgrade, MTN265TXTransmedics Inc · Belgrade, MTN266TDSd Capital Holdings LLC · Newark, DEN267TXTransmedics Inc · Belgrade, MTN26BJim & M LLC · Naples, FLN272NRNeary Daniel P · Omaha, NEN275JSJssi Parts LLC · Chicago, ILN276TXTransmedics Inc · Belgrade, MTN277RWRodney Webb Aviation LLC · Fort Lauderdale, FLN278SC205 Development LLC · Northport, ALN27RRColumbia Asset Trust Corp Trustee · Wichita, KSN282GSMississippi Queen Partners LLC · Naples, FLN282TXTransmedics Inc · Belgrade, MTN283CPCommerical Bag Company · Bloomington, ILN283TXTransmedics Inc · Belgrade, MTN284TXTransmedics Inc · Belgrade, MTN285TXTransmedics Inc · Belgrade, MTN287TXTransmedics Inc · Belgrade, MTN289TXTransmedics Inc · Belgrade, MTN290TXTransmedics Inc · Belgrade, MTN291TXTransmedics Inc · Belgrade, MTN292TXTransmedics Inc · Belgrade, MTN293CKM&M Aircraft Group LLC · Aurora, ILN293TXTransmedics Inc · Belgrade, MTN294TXTransmedics Inc · Belgrade, MTN295TXTransmedics Inc · Belgrade, MT
Back to AD 2025-05-13