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.

N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350 N302USolomon Mark Trustee · Wilmington, DEBuilt 1964 · S/N 18255529 N302VMWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995322 N302WDivine John S III DBA · Myrtle Beach, SCS/N E-302 N302ZSutherland Derrick L · Ada, OKBuilt 1960 · S/N CD-201 N30301Brown Gregory R · Spotsylvania, VABuilt 1962 · S/N CD-450 N3030DBoardwalk Management LLC · Kalispell, MTBuilt 1999 · S/N E-3230 N3030EElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 17271408 N3030FThirty Thirty Club · Lebanon, ORBuilt 1966 · S/N 18257130 N3030JJav Air LLC · Scottsdale, AZBuilt 1978 · S/N 32R-7987076 N3030MIn Line Aviation LLC · Greensburg, PABuilt 1977 · S/N 28R-7837109 N3030SBrewer Mike · Cameron Park, CABuilt 1978 · S/N E-1280 N3030UAll Around Inc · Ramseur, NCBuilt 1963 · S/N 17250630 N3030WZadnik Gary R · Vacaville, CAS/N 24-3534 N3030YSamaniego Alejandro · Tucson, AZBuilt 1962 · S/N 18254030 N30314Tropic Breeze Leasing And Management LLC · Wilmington, DEBuilt 1978 · S/N 32R-7885085 N3031APhoenix Flight LLC · Cave Creek, AZBuilt 1979 · S/N 32R-7987018 N3031DApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995142 N3031FAlderson John M · Venice, CABuilt 1966 · S/N 18257131 N3031KCrowder John K · Rutherfordton, NCBuilt 1979 · S/N 28R-7918027 N3031LCavender Kelly P · Prosper, TXBuilt 1965 · S/N 310J0031 N3031QBrut N3031q · Los Angeles, CAFirst renewal noticeBuilt 1998 · S/N E-3196 N3031RSearch Gordon · Joliet, ILBuilt 1960 · S/N 39115 N3031USandstrom David E · Anchorage, AKBuilt 1963 · S/N 17250631 N3031WParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916348 N3031YAir Repair Inc · Cleveland, MSBuilt 1962 · S/N 18254031 N30322Caballeros Aircraft LLC · Snohomish, WABuilt 1978 · S/N 28-7990090 N30325N30325 LLC · Lakeland, FLBuilt 1978 · S/N 28R-7837313 N3032ALynn University Inc · Boca Raton, FLS/N 3449294 N3032CPrice Michael J · Pulaski, NYS/N D-5687 N3032KDamian Richard Eugene · Sioux Falls, SDBuilt 1979 · S/N 28R-7918028 N3032LBlue Sky Air Ventures LLC · Wilmington, DEBuilt 1999 · S/N EA-632 N3032PMenard Charles H · Grand Blanc, MIBuilt 1957 · S/N 23-943 N3032QMitchell Michael A · Old Forge, NYBuilt 1967 · S/N 18258032 N3032TGreen Canyon Aviation LLC · Kalispell, MTBuilt 1979 · S/N 28-7916304 N3032WDebrouwer Isabelle Mc · Alpine, TXBuilt 1973 · S/N D-9525 N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869 N3033CMetzger James R · Payette, IDBuilt 1958 · S/N D-5688 N3033DYakima Aero Club · Yakima, WABuilt 1978 · S/N 28-7916157 N3033MPhil-Flyers Club Inc · Amarillo, TXBuilt 1977 · S/N 28R-7803160 N3033NVyse Aviation LLC · Deer Park, ILBuilt 1979 · S/N 44-7995227 N3033QFisher David E DBA · Bristow, OKBuilt 1967 · S/N 18258033 N3033TPurdue Pilots Inc · West Lafayette, INBuilt 1979 · S/N 28-7916305 N3033WRegistered aircraftBuilt 1979 · S/N 28-7911138 N3034CTyler Bonnie Flying LLC · Tyler, TXBuilt 1986 · S/N E-2341 N3034GArcher II Ltd · Hebron, OHBuilt 1978 · S/N 28-7990196 N3034JFlitton Mark S · Enterprise, ALFirst renewal noticeBuilt 1949 · S/N 18774 N3034LTown Thomas L · Chino Valley, AZBuilt 1965 · S/N 310J0034 N3034QLibra Air Inc · Las Vegas, NVBuilt 1977 · S/N 28-7716132 N3034TVelez Investments LLC · Orlando, FLS/N 320C0034

Back to AD 98-21-21 R1