AD 2000-26-20
Registered aircraft · 59
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:2000-26-20')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-26-20')
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:2000-26-20') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-26-20') 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.
N118JKRegistered aircraftN127GKAlliance Aviation Group LLC · Wilmington, DEN163PAN163pa LLC · Wilmington, DEN173PAN173pa LLC · Wilmington, DEN175BGMile High Holdings LLC · Miami, FLN17LKAircraft Holding Solutions LLC Trustee · Newark, DEN183PASandy Wings LLC · Wilmington, DEN184PABartowjets LLC · Wilmington, DEN190PASandy Wings LLC · Wilmington, DEN195PASandy Wings LLC · Wilmington, DEN196PASandy Wings LLC · Wilmington, DEN198PABartowjets LLC · Wilmington, DEN218EESolomon Mark Trustee · Wilmington, DEN234LRDanish Jet Inc Trustee · Cheyenne, WYN303MPAir Cargo Services LLC · Miami, FLN30501Dutchess Community College · Poughkeepsie, NYN305LRAircraft Holding Solutions LLC Trustee · Newark, DEN30LXN492a LLC · Goodyear, AZN30WRInfotech Management Inc · San Diego, CANon-citizen corporation, flight hours not reportedN313MSEpic Rise LLC · Tulsa, OKN320MKAdaka-Sb LLC · Orlando, FLN324JWVip Jet Transportation Inc · Bishop, CAN32MJAviation Company Inc · Cheyenne, WYN337LRJetsteam Aviation Inc · Cheyenne, WYN356BRBdp Airways LLC · Dover, DEN358CYBondio LLC · Great Neck, NYN36DZSmb Giii LLC · Longwood, FLN388MMAc Travel LLC · Palm Beach, FLN3DPAircraft Holding Solutions LLC · Newark, DEN404AAPacific Rim Management LLC · Downey, CAN413WJN492a LLC · Goodyear, AZN416WMKen Sale Resource Inc · Southlake, TXN44HBBartowjets LLC · Wilmington, DEN456BEBillionaire Inc · St Petersburg, FLN457JCExceptional Aircrafts LLC · Mcallen, TXN461ARSolo Energy Drink Inc · Miramar, FLN467AMBank Of Utah Trustee · Salt Lake City, UTN478VTTipnes Aviation LLC · Tampa, FLN492AN492a LLC · Gilbert, AZN501JVJetvue Texas LLC · Richardson, TXN50BHTravel Link LLC · Vienna, VAN510FROneflight International Inc · Englewood, CON520NANasa Langley Research Center · Hampton, VAN550JFTs Aviation LLC · New York, NYN555DWInstitue Of Aeronautical And Aerospace Institute · Aguadilla, PRN608BGN A S A Lyndon B Johnson Space Center · Houston, TXN710CFCalspan Corp · Niagara Falls, NYN711UFDodson International Parts Inc · Rantoul, KSN714DSPhoenix Air Group Inc · Cartersville, GAN721CFCalspan Corp · Buffalo, NY
Back to AD 2000-26-20