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.

N2828QJack Dixon · Haiku, HIBuilt 1971 · S/N 17259828 N2828UWolf River Aviation LLC · Memphis, TNBuilt 1979 · S/N 28-7911192 N2828YHooey Kevin M · Beaver Dams, NYBuilt 1962 · S/N 18253828 N2829EEverts Air Service Inc · Sarasota, FLBuilt 1978 · S/N 17271336 N2829LGeaux Fly LLC · Bossier City, LAS/N 17256029 N2829QL & L Aviation LLC · Sidney, NEBuilt 1971 · S/N 17259829 N2829TSeal Dennis J · Dallas, TXS/N 28-7225243 N2829URc Dakota Aviation LLC · Denville, NJBuilt 1979 · S/N 28-7911194 N2829YN2829y LLC · Longmont, COFirst renewal noticeBuilt 1962 · S/N 18253829 N282BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842418 N282BLBlue Line Aviation LLC · Winter Haven, FLBuilt 2023 · S/N 2881674 N282CPWright Andrew T · Clyde, OHBuilt 1958 · S/N 51546 N282DXPiper Aircraft Inc · Vero Beach, FLS/N 28010106 N282EAGalaxy Lift II LLC · Blountville, TNS/N TH-2082 N282EL282el LLC · Pendleton, ORS/N 182-67682 N282HGCompass Rose 2 LLC · Austin, TXBuilt 1995 · S/N 2842007 N282HPSale Reported · OxonSale reportedBuilt 2000 · S/N 2843354 N282JLSieck Joshua · Edmond, OKBuilt 1967 · S/N TE-355 N282JPMarshalls Sanitation Services LLC DBA · Fallon, NVBuilt 1977 · S/N 18265923 N282MBMitchell Larry N · Fredericksburg, TXBuilt 2000 · S/N 2843366 N282MKAlpe Holding LLC · Van Nuys, CABuilt 2003 · S/N 2842188 N282NDMoore Aviation Inc · Beaver Falls, PABuilt 2000 · S/N 2844024 N282PGitlow Stuart · Woonsocket, RIBuilt 1964 · S/N 30-508 N282PHMission Padamo Aviation And Support Inc · Luray, VABuilt 1980 · S/N U20606068 N282RTenere Ventures LLC · Wilmington, DEBuilt 1981 · S/N CE-951 N282RFDevault Michael E · Fairmont, WVBuilt 1968 · S/N 18259466 N282TWLake Of The Woods Aviation LLC · Baudette, MNBuilt 1977 · S/N 18265943 N2830AMarathon Heater Inc · Del Rio, TXBuilt 1970 · S/N E-201 N2830JPagano Nathan J · New Haven, CTBuilt 1979 · S/N 28-7916456 N2830LPilotpros Training LLC · Longview, TXBuilt 1967 · S/N 17256030 N2830QRetro Modern Aviation LLC · Manitou Springs, COBuilt 1971 · S/N 17259830 N2830RCae Flying Club Of Ohio · Toledo, OHBuilt 1967 · S/N 18258430 N2830TThree Zero Tango Corporation · Wentzville, MOBuilt 1972 · S/N 28-7205229 N2831CMohar Fred B Jr · Turner, MTBuilt 1954 · S/N 26374 N2831KBjorkman Glenn A · Goleta, CABuilt 1979 · S/N 18053092 N2831LJkj Flying LLC · Chittenango, NYBuilt 1967 · S/N 17256031 N2831TMesiemore Roger · Lake Wylie, SCBuilt 1972 · S/N 28R-7235141 N2831USchmidt Paul D · Whitesburg, GABuilt 1963 · S/N 17250431 N2832CVandehei Linda I · Fairbanks, AKBuilt 1954 · S/N 26375 N2832MCronin Terrance F · Federal Way, WABuilt 1977 · S/N 28-7816316 N2832RMabe Bradley L · Cascade, IDBuilt 1967 · S/N 18258432 N2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMBuilt 1972 · S/N 28R-7235142 N2832URegistration Pending · Wasilla, AKRegistration pendingS/N 17250432 N2833AMamuzich Robert J DBA · Deming, NMS/N 30033 N2833CKizer Charlene A · Albany, ORBuilt 1978 · S/N R18200234 N2833DScott Glen H · Spring, TXBuilt 1979 · S/N 28-7916451 N2833FWeaver Arnold G · Sandusky, MIBuilt 1979 · S/N 28-7916452 N2833LWade Kenneth L · Huron, TNBuilt 1967 · S/N 17256033 N2833NLansing Community College · Mason, MIBuilt 1979 · S/N 28-7916453 N2833RRegistered aircraftS/N 18258433

Back to AD 98-21-21 R1