Registered aircraft · 27

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

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:81-16-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-16-08-R3') ORDER BY n_number

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:81-16-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-16-08-R3')
  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:81-16-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-16-08-R3')
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.

N100WNColumbus State Community College · Columbus, OHBuilt 1979 · S/N 288 N107RMDierolf Robert Scott · Carrollton, TXBuilt 1982 · S/N 362 N108FLWyoming Aviation Specialist Inc · Green Valley, AZS/N 300 N111FNBest Aircraft Deals LLC · Salt Lake City, UTS/N 293 N123DGDavis Air LLC · Vero Beach, FLBuilt 1976 · S/N 342 N165CMUS Crane LLC · Wilmington, DES/N 355 N17AHSpirit Wing Aviation Ltd · Guthrie, OKBuilt 1980 · S/N 316 N203VSCalspan Corp · Buffalo, NYBuilt 1981 · S/N 347 N25CYN25cy LLC · West Palm Beach, FLS/N 272 N25NYAndrews University · Berrien Springs, MIBuilt 1980 · S/N 304 N25PWSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N 342 N304VSCalspan Corp · Buffalo, NYBuilt 1981 · S/N 354 N330LA-C Electric Co · Bakersfield, CABuilt 1981 · S/N 330 N352MDDolphin Aviation LLC · Tulsa, OKBuilt 1977 · S/N 352 N4447PAviation Management & Repairs Inc · Fort Pierce, FLS/N 338 N444TGAmerican Trans Air Training Corp · Virginia Beach, VABuilt 1980 · S/N 327 N456CGLdl Aircraft Leasing LLC · Pittsfield, MABuilt 1981 · S/N 343 N499BSNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 239 N49GSAvstar Inc · Seattle, WABuilt 1976 · S/N 336 N56MMCarlisle Air LLC · Locust Valley, NYBuilt 1976 · S/N 332 N600GMTeterboro School Of Aeronautics DBA · Hasbrouck Heights, NJS/N 290 N657BMFairway Aviation Leasing Co LLC · Wilmington, DES/N 331 N727LMLacey Doug DBA · Laredo, TXS/N 25D308 N890MJJensen Mark A · Dallas, TXBuilt 1977 · S/N 229 N894CJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1976 · S/N 335 N988AADodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 348 N988ASDutchess Community College · Poughkeepsie, NYS/N 257

Back to AD 81-16-08 R3