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.

N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023 N15MZCaillarec Philippe · Le RheuNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28R-7803274 N15NCHerberg Hayley · Reno, NVBuilt 1966 · S/N CE-12 N15NFRegistered aircraftBuilt 1969 · S/N 17258204 N15PCollins Jeffery S · Griffin, GABuilt 1956 · S/N DH-92 N15PAFlight Dynamics LLC · De Leon Springs, FLBuilt 1980 · S/N 18053148 N15PHBindon Phil E · Wasilla, AKFirst renewal noticeBuilt 1958 · S/N RLH-20 N15PMDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N E-1016 N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388 N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568 N15RDWood Richard W Trustee · Oroville, CABuilt 1978 · S/N E-1407 N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068 N15RJColston David T · Vero Beach, FLBuilt 1968 · S/N CE-199 N15RPKnob Creek Aviation LLC · Oak Ridge, LABuilt 1974 · S/N E-539 N15RSCalvert Gregory E · Essex, MDBuilt 1973 · S/N 18261885 N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875 N15TTray Aircraft Leasing LLC · Port Richey, FLBuilt 1964 · S/N TC-626 N15TBEast West Helicopter Inc · Batesville, INBuilt 1979 · S/N 21063331 N15TVDfl Management Corp · New Castle, DES/N 310R0945 N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676 N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936 N15WGSwirk Rhonda L · Center Conway, NHBuilt 1968 · S/N 18259444 N15WRAcmc Operations LLC · Cedar Park, TXBuilt 1975 · S/N 310R0553 N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226 N15XAMenigoz Michael Steven · Puyallup, WABuilt 1975 · S/N E-732 N15XLN15xl LLC · Conway, ARBuilt 1977 · S/N TC-2048 N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966 N15ZFRegistration Pending · Swan Valley, IDRegistration pendingBuilt 1977 · S/N 18052802 N1600GBrown David · Bell Buckle, TNBuilt 1959 · S/N DH-211 N1600XLd&B LLC · Show Low, AZS/N 21060636 N1601CRoss Dale · Washtucna, WABuilt 1953 · S/N 30301 N1601SRussell Bryan E · Joshua, TXS/N 28-7790057 N1601WSix Ten Ventures LLC · Grand Prairie, TXBuilt 1972 · S/N D-9360 N1602BBoyd Aaron · S San Fran, CABuilt 1979 · S/N 17272737 N1602FWilliams Richard E · Seaford, DEBuilt 1966 · S/N 17254997 N1602MEsparraguera Maria D · Havre De Grace, MDBuilt 1975 · S/N 18264390 N1602VRegistration Pending · Lucas, TXRegistration pendingBuilt 1974 · S/N 17263690 N1602WN1602w Bonanza LLC · Jacksonville, FLBuilt 1972 · S/N CD-1292 N1603CJackson Zachariah J · Brainerd, MNBuilt 1953 · S/N 30303 N1603EWright Michael A · Advance, NCBuilt 1978 · S/N 17271062 N1603FAbouelleil Hisham · Suffield, CTS/N 17254998 N1604FMorse Mark H · Lake Stevens, WABuilt 1966 · S/N 17254999 N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359 N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242 N1604YOcean Isle Aviation · Ocean Isle Beach, NCBuilt 1962 · S/N 17249304 N1605CMiller Robert H · South Beloit, ILBuilt 1953 · S/N 30305 N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950 N1606WParagon Airplane Leasing Co · Fort Myers, FLBuilt 1972 · S/N TC-1467 N1606YFellows James S Jr · Fawnskin, CABuilt 1962 · S/N 17249306 N1607CAmos Walt · Sandy, UTBuilt 1953 · S/N 30307

Back to AD 98-21-21 R1