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.

N1746GFrasier Samuel · Gainesville, FLBuilt 1962 · S/N D-6952 N1746H1746h LLC · La Mirada, CAS/N 28R-7737011 N1746RSky West Aviation Inc Trustee · Albuquerque, NMS/N R18200543 N1746THessing Dale C · Eagle, IDBuilt 1970 · S/N 28-7125064 N1747CConatser Patrick M · Homeland, CABuilt 1953 · S/N 30447 N1747FSmith Jason F · Ronkonkoma, NYBuilt 1966 · S/N 17255142 N1747GPalmenteri Louis J · Rhome, TXBuilt 1962 · S/N CD-492 N1747HRooks John S · Barrington, RIBuilt 1977 · S/N 28R-7703033 N1747JCromwell James A · Little Rock, ARBuilt 1968 · S/N 28-24165 N1747MMcmillan James D · Abilene, TXBuilt 1975 · S/N 18264425 N1747RFite Rodney Edward · San Lorenzo, CABuilt 1978 · S/N R18200544 N1747TErickson Carrian Brooke · Overland Park, KSBuilt 1970 · S/N 28-7125065 N1748DWilliams Bobby G · Simi Valley, CABuilt 1951 · S/N 20191 N1748FManning Malcolm · Senatobia, MSBuilt 1966 · S/N 17255143 N1748GRobar Aircraft Inc · Griffin, GABuilt 1962 · S/N CD-527 N1748JHaywood Aviation & Salvage LLC · Atlanta, TXBuilt 1968 · S/N 28-24167 N1748RNorthstar Holdings LLC · Anchorage, AKBuilt 1980 · S/N U20605438 N1748TBallard George M · Mchenry, ILBuilt 1970 · S/N 28-7125066 N1748WBas Part Sales LLC · Greeley, COBuilt 1972 · S/N TE-887 N1748ZRanz Douglas R · West Bloomfield, MIBuilt 1962 · S/N 205-0047 N1749TCollier Tony · Grayson, KYBuilt 1970 · S/N 28-7125067 N1749VVance Nicholas D · Bluffton, OHS/N 17263737 N174AAdkins Charles D · Apopka, FLBuilt 1957 · S/N 34535 N174AFWelch William H Jr · Owosso, MIBuilt 1959 · S/N D-6187 N174CAVy Aeroventure LLC · Bloomfield Hills, MIBuilt 1994 · S/N 3213080 N174DCAire Services LLC · Barrigada, GUBuilt 1980 · S/N 28-8190085 N174FVy Holdings LLC · Scottsbluff, NES/N 28-854 N174GPLittle Terry J · New Port Richey, FLBuilt 1979 · S/N R18201136 N174HLarsen Kevin L · Firth, IDBuilt 1955 · S/N 31512 N174HAKlin Trin Collectibles LLC · Downers Grove, ILS/N 17272235 N174JRyan Aviation LLC · Forest Hills, NYBuilt 1974 · S/N 28-7405193 N174JJRensi William C · Thornville, OHBuilt 1967 · S/N CD-1094 N174JPGeary Michael Fredrick · Seguin, TXBuilt 1971 · S/N 17259850 N174KBlueskies Aviation Services LLC · Charlestown, INBuilt 1968 · S/N 310N-0143 N174LSN174ls LLC · Middlebury, CTBuilt 1976 · S/N 18503086 N174PCMeyer Brian A · Milwaukie, ORBuilt 1973 · S/N 28-7425187 N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174 N174TATracewings LLC · Goodyear, AZS/N E-3499 N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73 N17505Trout Christopher S · Albuquerque, NMBuilt 1977 · S/N D-9966 N17509Starke Charles H III · Weirsdale, FLBuilt 1976 · S/N E-972 N1750FLeggett Lee D · Murfreesboro, NCBuilt 1966 · S/N 17255145 N1750HDileo Steven · Gallatin, TNBuilt 1977 · S/N 32R-7780189 N1750JBlackwood Aldon · Baltimore, MDBuilt 1968 · S/N 28-24169 N1750RShort James B · Anchorage, AKBuilt 1974 · S/N 18502470 N1750TVan Strand Investments LLC · Fruita, COBuilt 1970 · S/N 28-7125068 N1750WYounger Benjamin · Narrowsburg, NYBuilt 1972 · S/N D-9406 N17516Gillis Alan · Richmond, TXBuilt 1977 · S/N D-9978 N1751CFeaga Charles C Jr · Abbot, MES/N 30451 N1751GThaxton Todd J · Williamson, GABuilt 1962 · S/N CD-494

Back to AD 98-21-21 R1