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.
N277QSRegistered aircraftN278QSRegistered aircraftN279FXFlexjet LLC · Cleveland, OHN279QSRegistered aircraftN280QSRegistered aircraftN281FXFlexjet LLC · Cleveland, OHN282FXFlexjet LLC · Cleveland, OHN282QSCmbh Holdings LLC · Oklahoma City, OKN283FXFlexjet LLC · Cleveland, OHN283QSRegistered aircraftN284FXFlexjet LLC · Cleveland, OHN284QSRegistered aircraftN285QSRegistered aircraftN286QSAst Financial LLC · Oklahoma City, OKN287QS2024 Aviation LLC · Oklahoma City, OKN288QSArcflight LLC · Oklahoma City, OKN288SFPinnacle Bank · Columbus, GAN289QSAmphenol Corp · Oklahoma City, OKN290QSClear Air Aviation LLC · Oklahoma City, OKN291QSAttorney Aviation LLC · Oklahoma City, OKN292QSArna Marketing Group Inc · Oklahoma City, OKN293QSFerstler Management LLC · Oklahoma City, OKN294QS46 Energy Services LLC · Oklahoma City, OKN295QSExamworks LLC · Oklahoma City, OKN296QSRegistered aircraftN297QSRegistered aircraftN29PFPi International LLC · Sacramento, CAN308MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN30WDKing Aviation LLC · Dallas, TXN313CFEvans General Aviation LLC · Alpharetta, GAN316FXFlexjet LLC · Cleveland, OHN317FXStanley Steemer International Inc · Cleveland, OHN318FXFlexjet LLC · Cleveland, OHN319FXFlexjet LLC · Cleveland, OHN31MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLN320FXBraxton Aviation II LLC · Cleveland, OHN321FXConnie 749 LLC · Cleveland, OHN322FXYnwa LLC · Cleveland, OHN323FXRegistered aircraftN324FXBoardwalk Auto Group LLC · Cleveland, OHN325FXFlexjet LLC · Cleveland, OHN326FXTriple F Management LLC · Cleveland, OHN327FXCp Wings II LLC · Cleveland, OHN327YHMs Aviation Services LLC · Dover, DEN328FXFrank J Blair · Cleveland, OHN329FXFlexjet LLC · Cleveland, OHN32TSCsc Delaware Trust Company Trustee · Wilmington, DEN32TXPresidio Air Ventures LLC · Houston, TXN330FXRegistered aircraftN332FXPinto Marc · Cleveland, OH
Back to AD 2024-05-13