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.

N4857GVero Technical Support Inc · Pensacola, FLS/N 17273404 N4857JWogan Ted E · Russellville, ALBuilt 1968 · S/N 28R-30613 N4857LGlass Steven L · Knob Lick, KYBuilt 1967 · S/N 28-4207 N4857TWillis Donald H · Temple, TXS/N 28-7225224 N4857VNewsouth Aviation LLC · Auburn, ALBuilt 1980 · S/N 172RG0402 N4857WShelor Christina L · Virginia Beach, VABuilt 1976 · S/N 14187 N4858JSchapiro Stephen Alexander · Lambertville, NJBuilt 1968 · S/N 28R-30614 N4858LSolis Moises G · Austin, TXBuilt 1967 · S/N 28-4208 N4858TGuerra Thomas C · Montgomery, TXBuilt 1972 · S/N 28-7225225 N4859ADory Lakota L · Caldwell, IDS/N 22-4015 N4859FRidgway Stephen · Avon, COBuilt 1979 · S/N 17273089 N4859GAirgo Inc · Centralia, ILBuilt 1979 · S/N 17273406 N4859LDavinci Ventures Inc · Bolingbrook, ILBuilt 1967 · S/N 28-4211 N4859TRamirez-Pagan Abelardo · Copperas Cove, TXBuilt 1972 · S/N 28-7205210 N485AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843749 N485ABPrice Scott · Camas, WABuilt 1990 · S/N AB-485 N485BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881785 N485EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 27-3864 N485GRegistered aircraftBuilt 1980 · S/N 172RG0306 N485GAAlexander Glynn M · Miramar Beach, FLS/N 32-8006093 N485GBVergon Keith E · Osceola, INBuilt 2013 · S/N 99 N485JSPlaskett Mark G · King City, CAS/N 23485 N485MACunningham Richard · Justin, TXBuilt 2003 · S/N 0053 N485PBlackstone Stephen E · Southampton, NJBuilt 1965 · S/N 28-21078 N485SBLyddon Aero Center Inc · Liberal, KSBuilt 1978 · S/N 17271485 N485SYYoung Todd N · Mechanicsville, VAS/N 90820 N485TMitchell Lisa Marie · Lake Villa, ILBuilt 2004 · S/N 973-2004 N485VL & W Leasing LLC · Smyrna, TNBuilt 1999 · S/N 172S8316 N486Hagg Jeffrey D · Maysville, KYS/N 1678 N4860AWolff Paul J · Baraboo, WIBuilt 1956 · S/N 22-4019 N4860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842237 N4860YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4662 N48616Hall Stanley C · Sequim, WABuilt 1943 · S/N 78 N4861ARubbert Randy C · Reynolds, NDBuilt 1956 · S/N 22-4020 N4861GFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 17273408 N4861LPodolinski Frank · Greensburg, PABuilt 1967 · S/N 28-4213 N4861SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1979 · S/N R18201439 N4861VRegistered aircraftBuilt 1980 · S/N 172RG0403 N4862LGunter Gordon D · Green River, WYBuilt 1968 · S/N 28-4216 N4862YKohler Richard L · Moriarty, NMBuilt 1968 · S/N 25-4665 N4863ARud Alexandra E · Clara City, MNBuilt 1956 · S/N 22-4022 N4863LZimmerman Marlin · Muscoda, WIBuilt 1967 · S/N 28-4217 N4863SHogs LLC · Georgetown, SCBuilt 1970 · S/N 32-1290 N4863TM & M Light Transportation Co Inc · Duluth, MNBuilt 1981 · S/N R18201778 N4864DChiota Aviation LLC · Waco, TXFirst renewal noticeBuilt 1979 · S/N 17272377 N4864FFreely James John · Marshall, VAS/N 28-7790069 N4864GLazy Eights Holdings LLC · Greenwood, INBuilt 1979 · S/N 17273411 N4864LRegistration Pending · Boone, NCRegistration pendingBuilt 1967 · S/N 28-4218 N48652Lorenz John C · Edgewood, NMBuilt 1943 · S/N 135 N4865DBlack Hound Aviation LLC · Austin, TXS/N 17273904

Back to AD 87-10-06 R1