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.

N1836XRodney William Debaun Family Lp · Midlothian, TXBuilt 1964 · S/N 18255936 N1836ZBrown Farms Inc · Central City, NEBuilt 1981 · S/N CE-970 N18373T Mitchell Holdings Inc · Binghamton, NYBuilt 1981 · S/N TC-2415 N18378Lodi Airport Maintenance Corp · Las Vegas, NVS/N E-1106 N1837DSpivey Clay · Valdosta, GABuilt 1952 · S/N D-3099 N1837HYeagley Daun III · Moraine, OHBuilt 1959 · S/N 35937 N1837JTolley Derek Evan · Mckinleyville, CABuilt 1968 · S/N 28-24272 N1837LHornby Mark H · New Bern, NCBuilt 1976 · S/N D-9881 N1837TKettrey Keith · Waxahachie, TXBuilt 1971 · S/N 28-7105113 N1837ZBert Aviation LLC · Clemmons, NCBuilt 1981 · S/N D-10317 N18381Texas Aero Services 1 LLC · Frisco, TXBuilt 1977 · S/N CE-732 N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856 N18387Rizzuti Robert T · Theodosia, MOBuilt 1977 · S/N TC-2080 N1838CMcdevitt Daniel C · Social Circle, GABuilt 1953 · S/N 25982 N1838LGordon Martin A · South Amboy, NJS/N TC-2008 N1838MGenesis Aircraft Services Of Martin County LLC · Stuart, FLBuilt 1975 · S/N 18264461 N1838RSix Zero Zulu LLC · Kalispell, MTBuilt 1981 · S/N E-1916 N1838TN1838t LLC · Ballwin, MOBuilt 1971 · S/N 28-7105114 N1838XSkinner Norman D · Osceola, IABuilt 1964 · S/N 18255938 N1838ZAgee Mark L · Greenacres, WABuilt 1962 · S/N 205-0038 N18394Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1121 N18396Drec 0419 LLC · Carson, CAS/N TE-1109 N1839COploh Elli M · Makanda, ILBuilt 1953 · S/N 25983 N1839FHentz Randy Reuben · Tower City, PABuilt 1966 · S/N 21058739 N1839HFly 172n LLC · Peoria, AZBuilt 1977 · S/N 34-7770152 N1839RBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 18502554 N1839TBluewater Airmotive Corp · Wilmington, DEBuilt 1971 · S/N 28-7125262 N1839WTown & Country Auto Sales LLC · Winchester, KYBuilt 1973 · S/N TC-1514 N183BBRussell Charles B DBA · Union City, TNBuilt 1978 · S/N R18200310 N183CFCherokee Flyers Inc · Vero Beach, FLBuilt 1999 · S/N 2843232 N183CRBekway Builders LLC · Charleston, SCBuilt 1976 · S/N 18264029 N183EHarkins Harrison J Trustee · Hayden, IDBuilt 1982 · S/N E-2034 N183JPRegistration Pending · Anchorage, AKRegistration pendingS/N 180-52620 N183NMAfrican Parks Aviation Inc Trustee · Cheyenne, WYS/N 18263646 N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346 N183QDrajesk Jeffrey F · Fish Creek, WIBuilt 1965 · S/N D-7883 N183RLea Brandon Wayne Sr · Bartlett, TNBuilt 1957 · S/N D-5155 N183RLJe Air LLC · Bayamon, PRBuilt 1973 · S/N 17261654 N183SKHill Vicki · Saint Joseph, LABuilt 1977 · S/N 18052824 N183SPIndian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 172-68675 N183SVQuality Feed Grains Inc · Harrison, ARS/N 05-301031 N183VBRegistration Pending · Palm City, FLRegistration pendingBuilt 1977 · S/N E-1097 N18402Ohlhauser Devin · Bismarck, NDBuilt 1977 · S/N E-1117 N18403Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1120 N18404Cactus Aviation Llp · Gotha, FLBuilt 1977 · S/N E-1122 N1840DNewlin Thomas R · Montezuma, INBuilt 1952 · S/N D-3094 N1840VUnited States Air Force Owner · Apo, APBuilt 1974 · S/N 17263767 N1840WPutz Aeroplanes LLC · Bryan, TXBuilt 1973 · S/N D-9431 N18413Cook Brian D · La Vernia, TXBuilt 1977 · S/N CE-736 N1841RPatton Ronald V II · Keizer, ORBuilt 1974 · S/N 18502556

Back to AD 98-21-21 R1