Registered aircraft · 85,620

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-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N2440YMorristown Flying Service Inc · Talbott, TNBuilt 1962 · S/N 17249740 N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059 N2441RBelly Acres Capital And Management LLC · Memphis, TNBuilt 1964 · S/N 18255541 N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284 N2442CRoberts Calvin · Bluebell, UTBuilt 1954 · S/N 30742 N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285 N2442GRegistration Pending · King Salmon, AKRegistration pendingBuilt 1959 · S/N 51742 N2442LPratt Mark R · La Grande, ORBuilt 1966 · S/N 17255642 N2443DWeber Blake N · Sisters, ORBuilt 1952 · S/N 20595 N2443LOdlozil Henry W · Ennis, TXBuilt 1966 · S/N 17255643 N2443QHolcomb Aviation LLC · Middleton, IDS/N 18257643 N2443RYoung David E · Wasilla, AKBuilt 1964 · S/N 18255543 N2443UIntream Companies LLC · Perryville, MOBuilt 1963 · S/N 17250043 N2444DBennett James E · Fredericksburg, TXBuilt 1952 · S/N 20596 N2444GDurbin Brian · Lone Tree, COBuilt 1959 · S/N 51744 N2444QBristow Christopher W · Fairfield, TXBuilt 1966 · S/N 18257644 N2444RClancy Michael · Rifle, COBuilt 1964 · S/N 18255544 N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344 N2444YConrad Matthew J · Dardenne Prairie, MOBuilt 1962 · S/N 17249744 N2445UPeachey Jason J · Milroy, PABuilt 1963 · S/N 17250045 N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345 N2445YNew England Aircraft Detailing LLC · Webster, MAS/N 17249745 N2446CGolike Timothy R · Anchorage, AKBuilt 1954 · S/N 30746 N2446DGreen Griffin LLC · Powell, OHS/N 20598 N2446GAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 51746 N2446YMcmickle Edward R · Riverside, CAS/N 17249746 N2447CLevya Kevin S · Wilbur, WAS/N 30747 N2447GTroyer Thomas · Chickamauga, GABuilt 1959 · S/N 51747 N2447QEaton James B · Green Bank, NJBuilt 1966 · S/N 18257647 N2447RGift Academy Inc · Vernon, TXBuilt 1969 · S/N 28-5623 N2447UMccauley Stephen M · Buckley, WAS/N 17250047 N2447YNeu Aviation LLC · Benton, LABuilt 1962 · S/N 17249747 N2448DDrake Dwayne D · Fairbanks, AKS/N 20600 N2448EPwc Engine Air Inc · Manorville, NYS/N 17271288 N2448FFlynn Charles P · Anchorage, AKBuilt 1965 · S/N 18051648 N2448MSnider Robert Douglas Daniel · French Camp, CABuilt 1977 · S/N 28R-7803130 N2448QEuroaviation Inc Trustee · KematenS/N 18257648 N2448RRegistration Pending · Highland Lakes, NJRegistration pendingS/N 28-5624 N2448XBlough Robert M · Hoonah, AKBuilt 1965 · S/N 18256348 N2448YTennison William T · Osprey, FLBuilt 1962 · S/N 17249748 N2449DEdwards Samuel W · Shady Shores, TXBuilt 1952 · S/N 20601 N2449EWikette Mathias · West Chester, OHBuilt 1970 · S/N 28-26801 N2449FBoccuti Salvatore A · Ambler, PABuilt 1966 · S/N 18051650 N2449GDimzoff Justin W · Hines, ORFirst renewal noticeBuilt 1959 · S/N 51749 N2449JSkydance Northwestern Inc · Minden, NVBuilt 1982 · S/N 18504364 N2449LSteier Tim · Salome, AZBuilt 1966 · S/N 17255649 N2449QAcme Aircraft Co III LLC · Arvada, COBuilt 1966 · S/N 18257649 N2449UCurl Eric A · Olympia, WABuilt 1963 · S/N 17250049 N244AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881734 N244ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496043

Back to AD 98-21-21 R1