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.

N478WTBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 24-4634 N47905Hanson Larry A · Starkville, MSBuilt 1977 · S/N 28-7816155 N47906Brooks Jerry D · Fairmont, MNBuilt 1977 · S/N 28-7816156 N47907Macaulay Mark · Austin, TXBuilt 1977 · S/N 28-7890150 N4790ADaugherty Tighe L · Juneau, AKBuilt 1956 · S/N 22-3941 N4790EMahon Enterprises LLC · Gray Court, SCBuilt 1979 · S/N 17271655 N4790GWings Over Texas Holdings LLC · Denton, TXS/N 17273344 N4790JAmanzi LLC · Brasstown, NCFirst renewal noticeBuilt 1979 · S/N 17273677 N4790LFrodge Alan L · Crawfordsville, INBuilt 1967 · S/N 28-4126 N4790WHarms Joshua D · Carmi, ILBuilt 1979 · S/N 14518 N47914Ciolkowski Edward L · Webster, NYBuilt 1977 · S/N 32-7840018 N47918Hay Yotam · Johnson City, TNBuilt 1977 · S/N 28-7816158 N4791EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271656 N4791LWiley Scott C · Dothan, ALBuilt 1967 · S/N 28-4127 N4791VAmerican Eagle Realestate & Financing Corp · Royal Palm Beach, FLBuilt 1980 · S/N 172RG0379 N47920Barbeau Daniel P · Tullahoma, TNBuilt 1977 · S/N 28-7816160 N47923Stoehr Steven C Trustee · Ewing, NES/N 28-7890153 N47929Hylton Fitzroy C · Miramar, FLFirst renewal noticeBuilt 1977 · S/N 28-7816161 N4792ASeidl Reuben · Anchorage, AKBuilt 2009 · S/N 3943 N4792TBrooks Donald D · Baton Rouge, LABuilt 1972 · S/N 28R-7235109 N4792WHealey Carol L · San Francisco, CABuilt 1976 · S/N 14132 N4792YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4568 N4793EKillpack Kevin R · Rio Rancho, NMBuilt 1978 · S/N 17271658 N4793JSheco Inc · Aloha, ORBuilt 1967 · S/N MA-199 N4793LWhitley Carol E · Kingwood, TXBuilt 1967 · S/N 28-4130 N4793SArkansas Pilots For Christ Inc · Paragould, ARBuilt 1969 · S/N 32-1180 N47941Engineering Forensics Inc · Glen Burnie, MDS/N 28-7816167 N47943Louiewex Corp · Dover, DES/N 28-7890157 N47945Countee Roger Brendan · Los Angeles, CABuilt 1977 · S/N 28R-7837018 N4794LFerraro Henrik L · Grand Island, NYBuilt 1967 · S/N 28-4131 N4794YAir Kraft Spraying Inc · Timber Lake, SDBuilt 1968 · S/N 25-4572 N47953Mountain Aviation Associates LLC · Midland, TXBuilt 1977 · S/N 28-7816169 N47954Jennings James A · Fredericktown, OHS/N 28-7816170 N47955Southeastern Minnesota Flying Club Inc · Rochester, MNBuilt 1977 · S/N 28-7890159 N4795LN383j LLC · Henderson, NVBuilt 1967 · S/N 28-4132 N4795TCammack Van R Jr · Willow Park, TXBuilt 1972 · S/N 28R-7235110 N4795YPiper 4795y Aviation Services LLC · Colorado Springs, COBuilt 1968 · S/N 25-4573 N47961Thomas Brian E · Virginia Beach, VABuilt 1977 · S/N 32R-7880029 N47965Reid Brian M · Boise, IDS/N 28-7890156 N47968Grimes Mike · Yukon, OKBuilt 1977 · S/N 28-7816173 N47969Thomason Eric A · Georgetown, TXBuilt 1977 · S/N 28-7816174 N4796AThompson Muriel K · Eagle Pass, TXBuilt 1956 · S/N 22-3947 N4796VPittman Robert · Ocala, FLBuilt 1980 · S/N 172RG0381 N4796WHill David E · Ocala, FLBuilt 1976 · S/N 14116 N47971Five X Five Flight Inc · The Woodlands, TXBuilt 1977 · S/N 28-7890163 N47977Cossi Restaurant Corp · Ballston Spa, NYBuilt 1977 · S/N 32R-7880031 N4797SSmith Matthew · Seattle, WABuilt 1969 · S/N 32-1182 N4797WMiller Ronald J · Breckenridge, COS/N 14117 N47981Sabetha Flyers Inc · Sabetha, KSBuilt 1977 · S/N 28-7890164 N4798EClark Robert · Junction City, KSBuilt 1978 · S/N 17271663

Back to AD 87-10-06 R1