Registered aircraft · 9,459

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

N1002GFlying Fox Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 27-0295 N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078 N1005BRucker Casey J · West Linn, ORBuilt 1987 · S/N 4608091 N1005XSigler Lanny · Albuquerque, NMBuilt 2000 · S/N 27-0302 N1007VSmith Loren Dallas · Great Falls, MTS/N 73-31060 N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097 N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077 N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431 N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050 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 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100GFMenke Rex A · Medical Lake, WABuilt 1986 · S/N 46-8608060 N100GKLewis David B · Saint Louis, MOBuilt 1973 · S/N 210-59905 N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301 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 N100JDMark Aviation LLC · Kingsport, TNBuilt 1981 · S/N 414A0669 N100JRLumland Properties LLC · Winchester, VABuilt 1969 · S/N 31-599 N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429 N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535 N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957 N100NESanborn Map Co Inc · Colorado Springs, COS/N 31-7712022 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019 N100PCSmokey Bay Air Inc · Homer, AKBuilt 1978 · S/N 20700467 N100RTRanch 100 LLC · Fort Pierce, FLS/N 31-808 N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539 N100WDEveryday Medicine LLC · Nicholasville, KYBuilt 1982 · S/N 32-8224008 N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169 N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004 N1016XRadial Holdings LLC · Fort Worth, TXBuilt 2000 · S/N 27-0292 N101AXFogg Britt · Springdale, ARS/N P427 N101BHMpdkm Inc · Las Vegas, NVBuilt 2003 · S/N 01 N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066 N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602 N101LCReading Randall C · Redlands, CABuilt 1972 · S/N 31037 N101LPGranite Boarding LLC · Loomis, CABuilt 2004 · S/N T18208265 N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186 N101PAKeenan Mark · Chico, CABuilt 1979 · S/N EA-39 N101PLHay William G Jr · Gualala, CAS/N 27-7754156 N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062 N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381 N101YBCowan Lance E · Watonga, OKBuilt 1969 · S/N 31-406 N1021PYurok Tribe Construction Corp · Klamath, CABuilt 2005 · S/N T18208383 N10262Davoli Third Family Limited Partnership · Lighthouse Point, FLBuilt 2006 · S/N T18208495 N1026CMooney Howard James Jr · Lake Wales, FLBuilt 1995 · S/N 27-0203

Back to AD 2008-08-17