AD 2018-04-13
Registered aircraft · 1,373
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:2018-04-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:2018-04-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:2018-04-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:2018-04-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.
N438FCharter Central LLC · Morristown, TNN438FXFlexjet LLC · Cleveland, OHN439FXWarren Henry Automobiles Inc · Cleveland, OHN43FEFederal Express Leasing Corp · Memphis, TNN440AFN928gr LLC · Rancho Santa Fe, CAN440FXFlexjet LLC · Cleveland, OHN440JWJet Wind LLC · Salem, ORN441DTBank Of Utah Trustee · Salt Lake City, UTN441FXFlexjet LLC · Cleveland, OHN441JWGulf Shore 18s LLC · Naples, FLN443A443a Aviation LLC · Traverse City, MIN443DBGeoduck Aviation II LLC · Seattle, WAN443FXFlexjet 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, GAN447AKFriends Of Challenger LLC · Dover, DEN447FXFlexjet LLC · Cleveland, OHN448FXFlexjet LLC · Cleveland, OHN449FXFlexjet LLC · Cleveland, OHN44CPAlrick Holdings LLC · Wilmington, DEN44MMellon Seward Prosser · Laughlintown, PAN450AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN451GPGregory Poole Vector LLC · Raleigh, NCN451HMQuincy St LLC · Falls Church, VAN453FDShp-Air Leasing LLC · Wilmington, NCN454CLCrockett Air LLC · Raleigh, NCN454DBd Aviation LLC · Leawood, KSN455SMFifth Third Bank Na · Cincinnati, OHN456JAAquarius Aviation LLC · Cohoes, NYN457AYAix Fusion LLC · Scottsdale, AZN457WBRegis Funding V LLC · Ronkonkoma, NYN458TCRegistered aircraftN459MMi-Transport (Emb551) LLC · Brownsville, WIN45KKKoch Aviation LLC · Easton, PAN45MXSuperior Aviation LLC · Fort Wayne, INN45SEJsv Aviation Ventures 45se LLC · Dallas, TXN45TPEncore Aviation LLC · Jacksonville, FLN461EETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN465VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN466ACAriel Corp · Mount Vernon, OHN467MWSunstate Aviation LLC · Scottsdale, AZN468CESovereign Of The Sky LLC · Canonsburg, PAN46SMRegistered aircraftN46VENoble Plane LLC · Fishers, INN46WYJjc Holdings 2020 LLC · Richardson, TXN471BKWilmington Trust Co Trustee · Wilmington, DEN472ARColumbia Collier Properties LLC · Naples, FL
Back to AD 2018-04-13