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.

N25FAFly Rite Aviation LLC · Fort Myers, FLBuilt 1973 · S/N 34-7450047 N25FCBlumhagen Ryan M · Drake, NDBuilt 1955 · S/N 31520 N25FGState Of California Department Of Fish And Game · Sacramento, CAS/N 18504113 N25FPEastern Stearman Inc Trustee · Leesburg, VABuilt 1992 · S/N E-2720 N25FTPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754038 N25GPAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N U20602889 N25HGFiggins Darrin W · Ulysses, KSS/N 28-7890206 N25HHCorn Dustin M · Muncie, INBuilt 1953 · S/N D-3693 N25JFaria Manuel Steven Trustee · Tipton, CABuilt 1974 · S/N CE-536 N25JCAvg LLC · Chico, CABuilt 1959 · S/N 57008 N25JFBuckingham James M · Palmer, AKBuilt 1968 · S/N 27-3903 N25JGCenturion Aircraft Limited · Centennial, COS/N P21000329 N25JKCoastal Slr Corperation · Port Orange, FLBuilt 1968 · S/N TE-533 N25JRDjair · Winchester, VABuilt 1961 · S/N TC-132 N25JWFly 2 Hope LLC · Hilliard, FLBuilt 1962 · S/N 2004 N25KWFlyguys Holdings LLC · Yardley, PABuilt 2000 · S/N 3246175 N25LCParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020120 N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748 N25LRRoam Airlines LLC · Eugene, ORBuilt 1981 · S/N EA-196 N25LSBzaviation LLC · Saint Louis, MOBuilt 1994 · S/N E-2838 N25LTCaudell Currin B · Dallas, TXBuilt 1957 · S/N D-5330 N25MHumble Ventures Inc · Tempe, AZBuilt 1965 · S/N 24-4221 N25MJHb Flying LLC · Pampa, TXS/N E-3236 N25MMFairweather Aviation Leasing LLC · Haines, AKFirst renewal noticeBuilt 1975 · S/N 18502827 N25PDKnew Man Group LLC · New Orleans, LABuilt 1994 · S/N 3448050 N25PGOnizuka Michitaka · Broomfield, COBuilt 1977 · S/N 28-7790523 N25PKPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754105 N25PLWaterboy Aviation LLC · Richlandtown, PABuilt 1967 · S/N 28-23540 N25PRInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1511 N25QGrant Janice · Friday Harbor, WABuilt 2001 · S/N E-3398 N25QYCuller Richard E · Winston Salem, NCBuilt 1976 · S/N CE-653 N25RDHamilton Robert L · Vashon, WABuilt 1971 · S/N CE-358 N25RHPoseidon Transport Inc · Watertown, NYBuilt 1982 · S/N CE-1009 N25RMSky Travel LLC · Clayton, MOS/N TJ-459 N25RXOlde Same Place LLC · Thiensville, WIBuilt 1971 · S/N TE-832 N25SCBlain Robert John · Billings, MTBuilt 1966 · S/N 185 1055 N25SKH & H Aviation Enteprises LLC · Fairfield, OHBuilt 1979 · S/N 17273152 N25TMYankee Tango Mike LLC · Dublin, TXS/N EA-265 N25UPNewsome Jeffery S · Blackwell, OKBuilt 1977 · S/N E-987 N25UXBurgundy Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 3257178 N25VBOtto Aircraft Sales Inc · Sarasota, FLBuilt 1976 · S/N D-9841 N25WDSale Reported · Greeley, COSale reported, canceledBuilt 1978 · S/N P21000094 N25WEK & R Aviation LLC · Lubbock, TXBuilt 1981 · S/N 32R-8113039 N25WWRainey Aerial Ag Service Inc · Obion, TNBuilt 1976 · S/N E-842 N25XXWings Of Joy Foundation · Wilmington, DEBuilt 1979 · S/N 24-0826 N25ZZ25zz LLC · Abilene, TXS/N 18267202 N2600DJudge Eli A · Whitefish, MTBuilt 1952 · S/N 20752 N2600FZorrilla Peter · Charles Town, WVS/N 18256700 N2600GBad Company Aviation LLC · Peachtree Corners, GABuilt 1959 · S/N 51900 N2600LN2600l LLC · Pageland, SCBuilt 1967 · S/N 17255800

Back to AD 98-21-21 R1