Registered aircraft · 3,961

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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N421HLDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 421C0820 N421HMGottshall Curt · Monroe, WABuilt 1970 · S/N 421B0029 N421HPDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 421C0831 N421HRRons Air Service Inc · Two Buttes, COS/N 421B0945 N421HSQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 421C0621 N421HT421 Aviation LLC · Hale Center, TXBuilt 1977 · S/N 421C0297 N421HZDickert Investments - Flying Dicks LLC · Cave Creek, AZBuilt 1972 · S/N 421B0260 N421J421j LLC · Chuckey, TNS/N 421C0208 N421JCLonestar Aviation LLC · Las Cruces, NMBuilt 1981 · S/N 421C1099 N421JEBrown Lawson M II DBA · San Diego, CABuilt 1981 · S/N 421C1057 N421JFJadewood Ventures Inc · Santa Maria, CAS/N 421C0411 N421JHHolland Air LLC · Sharon Center, OHS/N 421C0875 N421JJSky Chariot LLC · Shafter, CABuilt 1977 · S/N 421C0294 N421JLWagner Distributing Co Inc · Auburn, CABuilt 1977 · S/N 421C0210 N421JMSchuck James M · Downey, CABuilt 1975 · S/N 421B0956 N421JNN421jn Aviation LLC · Wichita Falls, TXS/N 421C1245 N421JPKiser Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 421C0505 N421JR421jr LLC · Wichita, KSBuilt 1976 · S/N 421C-0094 N421JSBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 421C0033 N421JTPetty Flying Service Inc · Munday, TXBuilt 1979 · S/N 421C0666 N421JWWheels Up Aviation LLC · Edmond, OKBuilt 1979 · S/N 421C0665 N421KGWhite Star Aviation LLC · Wilmington, NCBuilt 1979 · S/N 421C0674 N421KMWeatherproof Montana LLC · Missoula, MTBuilt 1976 · S/N 421C-0006 N421KSEnvironmental Manufacturing Solutions Ltd · Melbourne, FLBuilt 1973 · S/N 421B0507 N421LCampbell Inc · Williamston, SCS/N 421C1013 N421LAChristensen Aaron M · Rapid City, SDS/N 421C1219 N421LCApi Aviation Leasing LLC · North Venice, FLBuilt 1975 · S/N 421C0053 N421LEN421le LLC · High Springs, FLS/N 421C0464 N421LFHaynes Aviation LLC · Caruthersville, MOS/N 421C0059 N421LG421cm LLC · N Charleston, SCS/N 421C1114 N421LHCreel Skies LLC · Myrtle Beach, SCBuilt 1981 · S/N 421C1207 N421LKParadise Flyers LLC · Summerland Key, FLBuilt 1981 · S/N 421C1017 N421LLWhirlybird Aviation LLC · Bend, ORBuilt 1983 · S/N 421C1081 N421LQApex A & K LLC · Englewood, FLBuilt 1980 · S/N 421C0883 N421LYMayes John S · Austin, TXBuilt 1980 · S/N 421C0855 N421MBIowa Trenchless LLC · Panora, IAS/N 421C0849 N421MCBlue Bottom Inc · Los Angeles, CABuilt 1972 · S/N 421B0321 N421MDBoss Contract Services LLC · Terry, MTBuilt 1978 · S/N 421C0516 N421MEMeisner Aircraft Inc · Janesville, WIBuilt 1976 · S/N 421C0074 N421MFGti Leasing LLC · Atlanta, GAS/N 421C0298 N421MGCowtown Aviation LLC · Hastings, NES/N 421C0662 N421MLLps Utilities Inc DBA · Woodstock, ILBuilt 1981 · S/N 421C0880 N421MRQuest Aviation Inc · Lake City, FLBuilt 1968 · S/N 421-0112 N421MUN421mu LLC · Missoula, MTBuilt 1977 · S/N 421C0248 N421MWRice Melvin Gaylon · Bridgeport, TXBuilt 1968 · S/N 421-0058 N421MYOzark Trails Youth Services Inc · West Plains, MOS/N 421B-0356 N421NGUltimate Airparts LLC · Strasburg, VAFirst renewal noticeS/N 421C0129 N421NLBas Part Sales LLC · Greeley, COS/N 421C0434 N421PDesert Aerostar LLC · Scottsdale, AZS/N 421C1092 N421PAPenley Steven A · Corinth, TXBuilt 1976 · S/N 421C0224

Back to AD 87-21-02 R1