Registered aircraft · 85,612

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.

N3007THorizon Air Ventures LLC · Fincastle, VABuilt 1997 · S/N 2843072 N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365 N30082Burnet Fredrick A · Monticello, UTBuilt 1978 · S/N 32R-7887268 N3008AMackenzie David Webb · Wilmington, DEBuilt 1978 · S/N 28-7916104 N3008BSedberry Jason A DBA · Kokomo, INBuilt 1978 · S/N 28-7990135 N3008CTech Aero Avionics LLC · Denton, TXBuilt 1958 · S/N D-5671 N3008EShore Gerald E · Inez, TXBuilt 1978 · S/N 17271401 N3008FShepherd Michael D · Rock Hill, SCBuilt 1978 · S/N 28-7916210 N3008RPerguson Robert C · Converse, TXBuilt 1962 · S/N 320A0008 N3008UNaperville Flying Club Inc · Woodridge, ILBuilt 1979 · S/N 28-7990333 N3008YWidmier Kolby J · Price, UTBuilt 1962 · S/N 18254008 N3009ARoberts Stephen · Camas, WABuilt 1953 · S/N 25653 N3009UEdgar Holly A · Tigard, ORBuilt 1979 · S/N 28-7990334 N300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1966 · S/N D-8056 N300BMohave Maverick Aviation LLC · Bullhead City, AZBuilt 1966 · S/N TC-1001 N300BDAircraft Inc · White Bear Lake, MNBuilt 1975 · S/N 310R0258 N300BHGreen Valley Corporation I · San Jose, CABuilt 1980 · S/N 32-8006011 N300BWWatson Brent J · Bountiful, UTBuilt 1965 · S/N 18256725 N300CACharlie Alpha LLC · Midland, MIBuilt 1973 · S/N 28-7305324 N300CLHustak Michael G · Granbury, TXBuilt 1969 · S/N D-8913 N300CPFuentes John Glen R · Warrenton, VABuilt 1984 · S/N 32R-8413014 N300DBEdeair LLC · Utica, MIBuilt 1979 · S/N 32-7940155 N300DCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842180 N300DESchmidt Arthur J · Tampa, FLS/N 34-7770157 N300DFDowner Justin W · Berthoud, COBuilt 1966 · S/N 18257109 N300DLSanta Barbara Flying Club · Santa Barbara, CABuilt 1978 · S/N 32-7840200 N300DTAlaska Bush Charters LLC · Dillingham, AKBuilt 1978 · S/N 32-7840174 N300EB4031 Pilots LLC · Crown Point, INBuilt 1974 · S/N 310R0082 N300EFMrr LLC · Schererville, INBuilt 1977 · S/N 28-7715267 N300EJPartwin LLC · Greenwich, CTBuilt 1974 · S/N 310Q1156 N300EMMark Thomas Productions LLC · Ketchum, IDBuilt 1966 · S/N 18257529 N300EW2f Trade LLC · Collinsville, TXS/N 21061219 N300HCPs Air LLC · Evansville, INBuilt 1983 · S/N 21064804 N300HVBaja Flyers Corp Inc · San Diego, CABuilt 1971 · S/N 32-7140026 N300JNK-M Air Enterprises Inc · Corona, CABuilt 1973 · S/N TC-1634 N300JPRedd James P Trustee · Eureka, CABuilt 1969 · S/N 32-40597 N300JRBeechcraft Heritage Museum · Tullahoma, TNBuilt 1968 · S/N TG70 N300JTMentor Capital LLC · San Antonio, TXBuilt 1978 · S/N 34-7970074 N300KKrakeel James A · Mount Pleasant, SCBuilt 1977 · S/N TE-1103 N300KRWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1976 · S/N 28R-7635210 N300KTKarnowski Ventures LLC · Manhattan, KSBuilt 1963 · S/N 18255095 N300KZDependable Aviation LLC · Cartersville, GABuilt 1961 · S/N 17248746 N300LCRobinson Russell J · Bridgeport, TXBuilt 1973 · S/N 17261520 N300LGSmith Foster F · Bishopville, SCBuilt 1980 · S/N 32-8024023 N300MConway Frank P · Sneads Ferry, NCBuilt 1978 · S/N 24-0630 N300MDHeywood Bruce N · Panguitch, UTS/N 400 N300MMHamblin Kenneth · Stanton, TNBuilt 1965 · S/N 30-851 N300MSChua Johann L · Daly City, CABuilt 1969 · S/N TE-688 N300NEBoone Steven E · Harrison, TNBuilt 1968 · S/N TC-1172 N300PAAero Maintenance Inc · Vancouver, WABuilt 1974 · S/N 28R-7435206

Back to AD 98-21-21 R1