Registered aircraft · 257

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

N402UWestern Ag Aviation Inc · Plains, KSBuilt 1999 · S/N 402A-1116 N402VA + Aviation Services LLC · Goodland, KSBuilt 1998 · S/N 402A-1050 N402WD402wd Holdings LLC · Corpus Christi, TXBuilt 1999 · S/N 402A-1090 N402WRHoxie Sprayers Inc · Hoxie, KSBuilt 2011 · S/N 402B-1244 N402YSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1285 N402ZSevcik Clint · Medford, MNBuilt 2012 · S/N 402B-1252 N4036FSaffer Spray Service Inc · Fowler, COS/N 402A-1058 N408ACOver & Under Flying Service Inc · Winamac, INBuilt 1993 · S/N 4010921 N409BRMehling Robert C · Hardin, MTS/N 4010909 N41068Woodley Aerial Leasing LLC · Walnut, ILS/N 402B-1174 N4172USki Ag Aviation LLC · Bismarck, NDBuilt 2010 · S/N 402B-1228 N420SAKingrey William S III · Richmond, TXBuilt 1990 · S/N 402-0776 N4215WAero Applicators Inc · Sterling, COBuilt 2009 · S/N 402B-1211 N4216KBecker Barton C · Oneill, NES/N 402A-1219 N422RDAir-Sprayers Inc · Two Buttes, COBuilt 2009 · S/N 402B-1224 N427AAAero Leasing LLC · Virden, ILS/N 402A-1032 N428JJKingrey William S · Richmond, TXBuilt 2014 · S/N 402B-1307 N42EAEscott Aerial Spraying LLC · El Reno, OKBuilt 2012 · S/N 402B-1269 N432DABob Donner Enterprises LLC · Belview, MNBuilt 1997 · S/N 401B-1029 N432WAWoodley Aerial Leasing LLC · Walnut, ILS/N 400-0435 N444ASAas LLC · Ovid, MIBuilt 1982 · S/N 400-0438 N444MSAas LLC · Ovid, MIS/N 400-0444 N45116Macys Flying Service Inc · Tulelake, CABuilt 1990 · S/N 401-0752 N45123Wood Flying Inc · Panhandle, TXS/N 402-0753 N4513WForest Flying Services Inc · Langdon, NDS/N 401-0754 N45196Boettcher Aerial Inc · Beloit, KSS/N 402-0755 N4523LWiebe Albert · Seminole, TXS/N 402-0757 N4527XSug-Air LLC · Lubbock, TXS/N 402A-0758 N4528LSkyworks Aviation LLC · Waynesboro, GAS/N 402A-0759 N4532FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0769 N4535UCga Holdings LLC · Kalispell, MTS/N 401-0773 N45363South Delta Aviation Inc · West Helena, ARS/N 402-0774 N45368Atlantic Ag Aviation Inc · Felton, DEBuilt 1990 · S/N 401-0775 N4539BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0763 N4539YHylands Agricultural Services LLC · Gretna, NES/N 401-0779 N4540FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 402-0784 N4541SKankakee Valley Aviation LLC · Wanatah, INS/N 402-0778 N45421Ascend Ag Inc · Wall, SDS/N 401-0786 N45469Over & Under Flying Service Inc · Madison, INBuilt 1991 · S/N 402A-0797 N45472Rtc Aviation LLC · Munday, TXBuilt 1991 · S/N 402A-0794 N4547QFarm Air Inc · Quanah, TXS/N 401-0792 N45492Woodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 401-0801 N4549EVertical Vegetation Management LLC · Darlington, INS/N 401-0765 N4552TMci Leasing LLC · Decatur, ILS/N 402-0750 N45553Racer Aviation LLC · Moorestown, NJBuilt 1991 · S/N 402-0818 N4555YDevil Dusters Inc · Artesia, NMBuilt 1991 · S/N 402-0812 N4556UAir Care Leasing LLC · Lamar, COBuilt 1991 · S/N 402-0815 N4556WVersaair Services LLC · Overland Park, KSBuilt 1991 · S/N 401-0817 N475LAPost Rock Aviation Inc · Lincoln, KSBuilt 2006 · S/N 402B-1175 N482ATAerinova Aerial LLC · Mattoon, ILBuilt 2013 · S/N 402B-1280

Back to AD 2006-08-08 R1