AD 75-15-06
Registered aircraft · 72
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:75-15-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-15-06')
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:75-15-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-15-06') 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.
N600GMTeterboro School Of Aeronautics DBA · Hasbrouck Heights, NJN606SMTechnical Education Services Inc · Virginia Beach, VAN657BMFairway Aviation Leasing Co LLC · Wilmington, DEN68LULewis University · Romeoville, ILN701SCAntares Aviation LLC · Boca Raton, FLN711CWPremier Jets Inc · Hillsboro, ORFirst renewal noticeN721SFSpirit Of Flight Foundation · Nampa, IDN725JSLopez Fabio A · Denver, NCN727LMLacey Doug DBA · Laredo, TXN73CEYanks Air Museum · Baldwin Park, CAN752EAAir Alliance Gt LLC · Lewes Sussex, DEN7701LLopez Fabio A · Denver, NCN823LJArtemis Aviation Group LLC · Kalispell, MTN890MJJensen Mark A · Dallas, TXN894CJCentral Virginia Aviation Inc · North Dinwiddie, VAN911AJMordtair Corp · HarareN91PNAero Nash Inc · Missoula, MTN924BWWings Over Texas Holdings LLC · Denton, TXN927FWTechnical Education Services Inc DBA · Virginia Beach, VAN929JGPittsburgh Institute Of Aeronautics · West Mifflin, PAN988AADodson International Parts Inc · Rantoul, KSN988ASDutchess Community College · Poughkeepsie, NY
Back to AD 75-15-06