AD 2024-05-13
Registered aircraft · 335
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:2024-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:2024-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:2024-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:2024-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.
N435FXFlexjet LLC · Cleveland, OHN436FXFlexjet LLC · Cleveland, OHN437FXFlexjet LLC · Cleveland, OHN438FXFlexjet LLC · Cleveland, OHN439FXWarren Henry Automobiles Inc · Cleveland, OHN440AFN928gr LLC · Rancho Santa Fe, CAN440FXFlexjet LLC · Cleveland, OHN441FXFlexjet LLC · Cleveland, OHN443FXFlexjet LLC · Cleveland, OHN444FXFlexjet LLC · Cleveland, OHN444LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN445FXFlexjet LLC · Cleveland, OHN446FXFlexjet LLC · Cleveland, OHN446LGFour Annie Aviation Leasing Company LLC · Kennesaw, GAN447FXFlexjet LLC · Cleveland, OHN448FXFlexjet LLC · Cleveland, OHN449FXFlexjet LLC · Cleveland, OHN454DBd Aviation LLC · Leawood, KSN455SMFifth Third Bank Na · Cincinnati, OHN458TCRegistered aircraftN459MMi-Transport (Emb551) LLC · Brownsville, WIN45TPEncore Aviation LLC · Jacksonville, FLN461EETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN466ACAriel Corp · Mount Vernon, OHN4752WNobska LLC · New Castle, DEN475PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN476FXPrc Partners LLC · Cleveland, OHN47MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLN482RSPraetor Ssi LLC · Lighthouse Point, FLN500KJJaffe Peter K · Hillsboro, ORN500MLBarkley Services LLC · Beaverton, ORN500NBRegistered aircraftN500VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN509EEBank Of Utah Trustee · Salt Lake City, UTN510SEStar Chaser LLC · Owensboro, KYN513CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN514LMWestmoreland Mechanical Aviation LLC · Youngstown, PAN514TXIe Aviation LLC · Price, UTN515GTWinston600 LLC · Santa Fe, NMN520MBSky Legacy LLC · Kalispell, MTN521MBRegistered aircraftN523WCN523wc Ltd · Niles, OHN527LGRegistered aircraftN52SFRdc 2 LLC · Fort Lauderdale, FLN532JKCrown Avaition Inc · Naples, FLN541GPGp Air Services Inc · Spring, TXN543EETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN54ENErgon Oil Purchasing Inc · Jackson, MSN54PPolaris Industries Inc · Medina, MNN54PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2024-05-13