Registered aircraft · 35,738

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

N10006Coutches Robert Hercules DBA · Livermore, CABuilt 1955 · S/N BG-72 N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839 N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000 N1000NAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1963 · S/N 310H0104 N1000QErnest Obregon · Oakley, CAS/N 310P0195 N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980 N1000V1kv LLC · Moultrie, GAS/N 0660 N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999 N1001QRegistered aircraftBuilt 1962 · S/N 310H0001 N10021Registered aircraftBuilt 2002 · S/N 30-0064 N1002QSwanson Dale A · Nashua, NHBuilt 1962 · S/N 310H0002 N10031Taylor Douglas Scott · Fairfield, CABuilt 2000 · S/N 29-0240 N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078 N1003LGill David P · Seabrook, TXBuilt 2001 · S/N 29-0272 N10045Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 29-0281 N10048Kumin Phillip R · Los Gatos, CABuilt 2002 · S/N 29-0282 N1004QChaudhary Rizvon · Louisville, KYBuilt 2000 · S/N 29-0241 N1004SRosenfeld Ronald S Trustee · Perry, MEBuilt 2003 · S/N 29-0289 N1005BRucker Casey J · West Linn, ORBuilt 1987 · S/N 4608091 N1005FBeam Douglas J Trustee · Chugiak, AKBuilt 1975 · S/N 18502677 N1005QRegistration Pending · Fairmont, WVRegistration pendingS/N 310H0005 N1006APressley Brent DBA · Morristown, TNBuilt 2002 · S/N 29-0284 N10079Wier Michael D · Pompano Beach, FLBuilt 2002 · S/N 30-0063 N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163 N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411 N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097 N1008RNicholas B Hall · Tampa, FLBuilt 2000 · S/N 30-0055 N1009MPrecision Wings LLC · Saint Augustine, FLBuilt 2002 · S/N 29-0287 N1009PFerrier William T · Woodland, CABuilt 1958 · S/N 34994 N1009QWatson James E Jr · Victor, COBuilt 1962 · S/N 310H0009 N100ANWatson Family Investments LLC · Houston, TXBuilt 1977 · S/N D-10084 N100BMarshall Xavier T · Carson, CAS/N 57114 N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536 N100CXCs Leasing LLC · Rockville, MDBuilt 1980 · S/N 414A0623 N100DBState Of Wisconsin · Madison, WIBuilt 1980 · S/N 21063970 N100DRWolfe Stephen Charles · Tulsa, OKBuilt 1976 · S/N TK-2 N100DXRegistered aircraftBuilt 1996 · S/N 29-0100 N100DZSkydive Santa Barbara LLC · Lompoc, CABuilt 1966 · S/N U206-0693 N100ERMid-South Aviation LLC · Caruthersville, MOBuilt 2016 · S/N TH-2461 N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158 N100FMRivkin Gerald · Saint Augustine, FLBuilt 1969 · S/N TE-729 N100FPFlying Particles Inc · Livermore, CABuilt 1974 · S/N 18262957 N100FRQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0770 N100GFMenke Rex A · Medical Lake, WABuilt 1986 · S/N 46-8608060 N100GKLewis David B · Saint Louis, MOBuilt 1973 · S/N 210-59905 N100GMHuguenard Jefferson J · Alpharetta, GABuilt 1968 · S/N TC-1183 N100HDLong Trace LLC · Madison, WIBuilt 1985 · S/N 46-8608003 N100HJClipper Air Inc · Tomball, TXBuilt 1974 · S/N 340-0334 N100HMSchultz David J · Neenah, WIBuilt 1978 · S/N 340A-0559 N100HPHinds Community College · Raymond, MSBuilt 1980 · S/N TK-116

Back to AD 98-01-08