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.

N29263Aviation Career Enrichment Inc · Atlanta, GABuilt 1979 · S/N 28-7916429 N29265Litchfield Flying Club Inc · Litchfield, MNBuilt 1979 · S/N 28-7990440 N2926JHutchens Wayne G · Atlanta, GABuilt 1979 · S/N 28-7911248 N2926LJade Aviation LLC · Minot, NDS/N 670320 N2926MDramstad Harold · Helena, MTBuilt 1975 · S/N 22-1282 N2926UBedi Kristopher · Fresno, CABuilt 1979 · S/N 28-7911250 N2926YViramontes Gilbert A · Temple City, CABuilt 1962 · S/N 18253926 N29274Brown Aero Technologies LLC · Alexander City, ALBuilt 1979 · S/N 28-7990442 N29278Pancho Moreno Y La Flaca LLC · Camuy, PRBuilt 1973 · S/N 21059852 N2927CMcvey Wesley · Frisco, TXBuilt 1979 · S/N 32-7940211 N2927ESchafer Thomas Charles · Caledonia, MOBuilt 1978 · S/N 17271374 N2927LStahl John R · Union Dale, PABuilt 1967 · S/N 670321 N2927MCooney Francis M · Sunriver, ORBuilt 1977 · S/N 28R-7837106 N2927QWifa (Washington International Flight Acad) LLC · Gaithersburg, MDS/N 28R-7737043 N2927UCarlson Brent A · Medford, ORBuilt 1963 · S/N 17250527 N2927VHereth Eric W · El Cajon, CAS/N D-311 N2927YReynolds Nathan W Jr · Piedmont, SCBuilt 1962 · S/N 18253927 N29282Avance Aviation LLC · Burlington, MABuilt 1979 · S/N 28-7990444 N29285Zrelak Patrick DBA · Apple Valley, CABuilt 1979 · S/N 28-7990446 N29286Wawro Christopher · East Troy, WIBuilt 1974 · S/N 17264114 N29289Disarro Wayne · Wasilla, AKBuilt 1968 · S/N U206-1211 N2928AVista Aircraft Lc · Papillion, NES/N 32-7940212 N2928DMatheny Kimberly D · Washington, WVS/N 26871 N2928LForristel Andrew · Temecula, CABuilt 1967 · S/N 670322 N2928RRonin Aero Group LLC · Coconut Creek, FLBuilt 1962 · S/N 310G0128 N2928UHeim Christopher J · Beavercreek, OHBuilt 1963 · S/N 17250528 N2928XBurger Andrew J · Cincinnati, OHBuilt 1979 · S/N 32-7940216 N2928YDiamond X LLC · Elko, NVBuilt 1962 · S/N 18253928 N29292Skytime Aviation LLC · Tulsa, OKBuilt 1968 · S/N U206-1212 N29296Crosby Gck LLC · Fort Worth, TXBuilt 1979 · S/N 28-7990447 N29299Svetic Russell T · Redondo Beach, CABuilt 1968 · S/N U206-1216 N2929BRegistered aircraftBuilt 1953 · S/N D-3570 N2929CSinnott Simonis Lyle · Girdwood, AKFirst renewal noticeBuilt 1954 · S/N 30829 N2929FSmith Lane R · Lewistown, MTBuilt 1966 · S/N 18257029 N2929NPekkala Ross F · Palmer, AKS/N 25545 N2929ULarson Michael J · Canton, ILBuilt 1963 · S/N 17250529 N2929VEllis Donald D W · High Springs, FLBuilt 1947 · S/N D-313 N292AWPalmetto Air LLC · Spartanburg, SCS/N 32-7840061 N292CAChoice Aviation LLC · Hamilton, MTBuilt 1976 · S/N 17266685 N292CBPelton Project · Keizer, ORBuilt 1975 · S/N 18264306 N292DAIndependence Youth Flying Club Inc · Independence, ORBuilt 1966 · S/N 17255066 N292EHGlorybe2 LLC · Saluda, SCBuilt 1965 · S/N 28-20943 N292GBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 3449224 N292HCarlisle Services LLC · Pine Mountain, GABuilt 1999 · S/N 3257094 N292HPMissimer N292hp LLC · Petaluma, CABuilt 2004 · S/N 2843587 N292JEEquinoxx Flight Systems LLC · Duluth, GABuilt 2022 · S/N 2881547 N292KFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17268188 N292LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020014 N292LGSale Reported · Miller, SDSale reported, pending cancellationBuilt 1975 · S/N 22-1232 N292LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881182

Back to AD 98-21-21 R1