AD 85-01-01
Registered aircraft · 317
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:85-01-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:85-01-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:85-01-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:85-01-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.
N39FBButler National Inc · New Century, KSN3DFTaurman Keith L · Virginia Beach, VAN3GCTexas Air & Space Museum · Amarillo, TXN3XBMonument Aviation LLC · North Chesterfield, VAN400RVMach Point Nine LLC · Phoenix, AZN403EMMach Point Nine LLC · Phoenix, AZN404JPParish Planes LLC · Tullahoma, TNN40BA711bn LLC · Miami, FLN410MCBank Of Utah Trustee · Salt Lake City, UTN411FTUS Aviation Corp · Miami, FLN416BKOptic Air LLC · Maurice, IAN416MRJosephine Air LLC · Castle Rock, WAN41BAFly Kronstadt LLC · Evanston, ILN41DZBravo Hotel LLC · Lewes, DEN422PMDale Aviation Inc · Rapid City, SDN427DMSky Charter LLC · Slidell, LAN431BGBismarck Air Medical LLC · Bismarck, NDN431RCentral Virginia Aviation Inc · North Dinwiddie, VAN43JTKolob Canyons Air Services Inc · Wilmington, DEN43MBSky West Aviation Inc Trustee · Albuquerque, NMN43WAWhatever Aviation LLC · Olympia, WAN4447WJvs86 LLC · Scottsdale, AZN44HPAime High LLC · Lake City, FLN45PRAslesen Leasin LLC · Halstad, MNN45SADavis Aviation Inc · Brandon, MSN463RSRts Aviation LLC · Atlanta, GAN465TASouthwest Aviation Specialties LLC · Tulsa, OKN469BUnited States Construction Corporation · Pompano Beach, FLN469JKQuest Aviation Inc · Lake City, FLN46AXGraber Joel · Collins, MSN46CVSky West Aviation Inc Trustee · Albuquerque, NMN4776MPassion Aviation LLC · Bells, TXN477MAircraft Unlimited Inc · Pierre, SDN478CRAlg Aircraft LLC · Delano, CAN479AKSafeco Leasing LLC · Port Alsworth, AKN479SAEarthcom Inc · Williamston, MIN484MCLee County Mosquito Control District · Lehigh Acres, FLN48AZStover Aviation LLC · Dallas, GAN490DMFlying Colors Air Parts Inc · Leesburg, FLN4947MKca Of Montana LLC · Helena, MTN495NMCentral Virginia Aviation Inc · North Dinwiddie, VAN49JPSumner Properties LLC · Somersworth, NHN4RYCentral Virginia Aviation Inc · North Dinwiddie, VAN500EQTxsd Holdings LLC · Amarillo, TXN501MSDodson International Parts Inc · Rantoul, KSN503CBCtb Inc · Goshen, INN50525Kansas State University · Salina, KSFirst renewal noticeN506AFCreedeair LLC · San Antonio, TXN5111PDe La Vega Artemio · Dallas, TXN5245FAex Aviation LLC · Davenport, FL
Back to AD 85-01-01