Skip to content

Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N40785Plane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N 34-7450079 N40787Henrich Perrin · Northridge, CABuilt 1973 · S/N 28-7425164 N4078BDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 31-8152055 N4078JStar Marianas Air Inc · Tinian, MPBuilt 1980 · S/N 31-8152057 N4078PHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1806 N4078RBrehmer Family Airplane LLC · Knoxville, TNBuilt 1967 · S/N 32-40392 N4078XEspey Brendan L · Sandy Springs, GABuilt 1970 · S/N 5178 N40798Hovnanyan Ari · Woodland Hills, CABuilt 1973 · S/N 28-7415087 N4079HWarbelow'S Air Ventures Inc · Fairbanks, AKBuilt 1981 · S/N 31-8152074 N4079PN4079p LLC · Peoria, AZS/N 23-1556 N4079XRichardson Scott · Grapevine, TXBuilt 1970 · S/N 5179 N4079ZNewton James K · Charles Town, WVBuilt 1963 · S/N 18-8093 N407AFRuff Brent M · Santa Clarita, CABuilt 1966 · S/N 30-1285 N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937 N407FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020207 N407FDVilkin Peter D · Palo Alto, CABuilt 1990 · S/N 772 N407FRRich Carolyn A · Redondo Beach, CABuilt 1997 · S/N 17280234 N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216 N407MNMaldonado Leopoldo · Paramount, CABuilt 1983 · S/N 407 N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545 N407TLBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 28R-7135013 N407WBBad Dog Aviation LLC · Wasilla, AKBuilt 1963 · S/N 18-8085 N407WYVerdoljak Corey · Homer, AKBuilt 1955 · S/N 18-4192 N407XCallahan Ashton G · Homer, AKS/N 7041C N40801Island View Flying Club · Goleta, CAS/N 28-7410049 N40806Sky Dream Flight School LLC · Dallas, GABuilt 1973 · S/N 28-7425169 N4080BIbrahim Phillip · Whitinsville, MABuilt 1974 · S/N 75-32-150 N4080WLance & Company LLC-S · Uniondale, INBuilt 1966 · S/N 32-40125 N4080ZVan Dyke Brian S · Rio Oso, CABuilt 1964 · S/N 18-8094 N40810Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7415088 N40812Dae Aviation Enterprises Corp · Gilford, NHBuilt 1973 · S/N 28-7405068 N40813Hendrix Charles W · Boca Raton, FLBuilt 1981 · S/N 31-8112040 N4081BCooley George · Cedar Rapids, IABuilt 1975 · S/N 75-32-161 N4081EOrlando Aircraft Sales LLC · Orlando, FLBuilt 1991 · S/N 1916 N4081SScheerer Martin · Edina, MNBuilt 1974 · S/N 28R-7435130 N40823Ashley Aviatrix LLC · Atlanta, GABuilt 1973 · S/N 28-7425173 N40829Shively Ray F · Turtlepoint, PABuilt 1973 · S/N 28-7415090 N4082JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1794 N4082RMid-Life Crisis Aviation LLC · Renton, WABuilt 1968 · S/N 32-40398 N4082TWarbelows Air Ventures Inc · Fairbanks, AKBuilt 1981 · S/N 31-8152089 N4082XLeach Joey D · Flat Rock, INBuilt 1971 · S/N 5182 N40830Spirit Of Rocky Mount LLC · Nashville, NCFirst renewal noticeBuilt 1973 · S/N 28-7415091 N40836Hawkins Joshua L · Colbert, GABuilt 1973 · S/N 28-7425176 N40838Andrews Mark F · Jacksonville, FLBuilt 1973 · S/N 28-7415093 N4083EHulsey Steven M · Chugiak, AKBuilt 1977 · S/N 18-7809056 N4083W13 Aviation LLC · Leesburg, GABuilt 1981 · S/N 31-8152099 N4083XKnutson Wayne R · Thompson, NDBuilt 1971 · S/N 5183 N4083ZRaymond Raphael T · Helix, ORBuilt 1964 · S/N 18-8098 N40842Avz Aviation Inc · Knoxville, TNBuilt 1973 · S/N 28-7415094 N40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1973 · S/N 28-7405070

Back to AD 87-10-06 R1