AD 75-06-01
Registered aircraft · 2,832
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-06-01')
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-06-01')
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-06-01') 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-06-01') 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.
N190GCMonarch Enterprises Inc · Kirkland, WAN190JPClearwater Midstream LLC · Lubbock, TXN190KMMec International Trading LLC · Mission, TXN190NCCf Holdings LLC · Hernando, MSN190WAAmeriflight LLC · Dallas, TXN191AVUas Transervices Inc · Boca Raton, FLN191AWCsi 135 Division LLC · Albuquerque, NMN191CSTvpx Ars Inc Trustee · North Salt Lake, UTN191DBMeridian Logistics LLC · Forest Lake, MNN191JRLocke-Lane Aviation LLC · Statesville, NCN191WAAmeriflight LLC · Dallas, TXN1927SBlue Sky Assets LLC · Garden Valley, IDN1928S1928 LLC · Salmon, IDN192KQShort Field Partners LLC · Bend, ORN192WAAmeriflight LLC · Dallas, TXN193KQAmerican O-Zones LLC · Tavernier, FLN193SUUas Transervices Inc · Boca Raton, FLN194CSNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTN194GAAlpine Aviation Inc · Provo, UTN195AAAir Travel Management LLC · Lemont Furnace, PAN195ALJmds Lift LLC · Helena, MTFirst renewal noticeN195GLAlpine Aviation Inc · Provo, UTN1967HTbm 700 LLC · Denair, CAN196LALocker Fred · Muleshoe, TXN196PK3m Ag LLC · Beebe, ARN196SCChickasaw Transport LLC · Santa Rosa Beach, FLN197RKArg Aviation LLC · Lexa, ARN197SCCharlie Ninety Alpha LLC · Searcy, ARN197WAAmeriflight LLC · Dallas, TXN1983XSouthern Airways Pacific LLC · Addison, TXN198LAVissair LLC · Rigby, IDN199CGGuardian Flight LLC · Lewisville, TXN199KQBridger Aviation Services LLC · Belgrade, MTN199YMicnic King Air LLC · Port Richey, FLN19CXSingle Windmill Ranch LLC · Austin, TXN19RZUas Transervices Inc · Boca Raton, FLN19TXPerry James · Monroe, WAFirst renewal noticeN1NGLewis Aeronautical LLC · San Antonio, TXN1PTWarner Aviation Properties LLC · Austin, TXN1SMStan Mcnabb Chevrolet Buick Gmc Cadillac Inc · Tullahoma, TNN1TCMarcare Aviation LLC · Gardnerville, NVN1TQWilmington Trust Co Trustee · Wilmington, DEN1VXMid America Sprayers Inc · Johnson, KSN200HKHck Aviation LLC · Jupiter, FLN200KQBridger Aviation Services LLC · Belgrade, MTN200MFMissionary Flights & Services Inc DBA · Fort Pierce, FLN200NDNorth Dakota Department Of Transportation · Bismarck, NDN200NWViking Transport LLC · Saint Louis Park, MNN200NYNew York State Police · Latham, NYN200PHPrairie Ventures Aviation LLC · Worthington, MNFirst renewal notice
Back to AD 75-06-01