Registered aircraft · 6,349

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:80-25-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2') 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:80-25-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
  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:80-25-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
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.

N9472LBradt Jeffrey A · Charlton, NYBuilt 1971 · S/N AA1A-0272 N9475TJohnson Marc · Westland, MIBuilt 1978 · S/N 38-78A0109 N94768Indian River Flying Club Inc · Rockledge, FLBuilt 1983 · S/N 15285782 N9476LJohnson Nicholas J · Cantonment, FLBuilt 1971 · S/N AA1A-0276 N9478LWeaver Iann · Polk, OHBuilt 1971 · S/N AA1A-0278 N94790Kingsky Flight Academy LLC · Lakeland, FLS/N 15285788 N9479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1978 · S/N 38-78A0110 N947ARPapoi Coral A · Sitka, AKBuilt 1972 · S/N 858-72 N947KCPeterson Cassandra L · Poplar Grove, ILBuilt 2018 · S/N 1412-2018 N947SFSnohomish Flying Service Inc · Snohomish, WABuilt 1983 · S/N 15285770 N94822Elon Aviation LLC · Burlington, NCBuilt 1983 · S/N 15285795 N9482TReid John · Emmett, IDBuilt 1978 · S/N 38-78A0111 N9483TLindley Mark E · Wakefield, RIBuilt 1978 · S/N 38-78A0113 N9484LHarrington Paul J · Queen Creek, AZBuilt 1971 · S/N AA1A-0284 N9485LRoll George N · Freeport, FLBuilt 1971 · S/N AA1A-0285 N94891Avcorp Holdings Inc · Jackson, MIBuilt 1983 · S/N 15285806 N9489LFord John C · Norman, OKS/N AA1A-0289 N9491LVictoria Angel Guaroa · Lewisville, TXBuilt 1971 · S/N AA1A-0291 N9494GKelly William W · Springfield, ORBuilt 1977 · S/N 15279527 N94959Lane Community College · Eugene, ORBuilt 1983 · S/N 15285823 N94963Twin Cities Air Service LLC · Gray, MES/N 15285825 N9499LRobinson Jason C · Fort Worth, TXBuilt 1971 · S/N AA1A-0299 N94FRFischer Michael A · Oak Park, ILBuilt 1995 · S/N FRF-1 N94SDKaeder Carpenter Deborah A · Inver Grove, MNBuilt 1947 · S/N 12-1711 N94SKKeen Douglas C · Munith, MIBuilt 1998 · S/N 200039 N95005Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 15285835 N95021Space Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 15285838 N95031Pratt John · Anchorage, AKBuilt 1984 · S/N 15285841 N9504TWilloughby Dan J · Linden, MIBuilt 1978 · S/N 38-78A0119 N9509LDexter Fred H · Live Oak, FLBuilt 1972 · S/N AA1B-0031 N950DTDanison George D · Decatur, ALBuilt 1969 · S/N AA1-0180 N950JCCorbett John P · Austell, GABuilt 2023 · S/N 1298 N95103Shelton Aviation Inc · Christiansburg, VABuilt 1984 · S/N 15285849 N95122Mcnamara Kevin M Jr · East Aurora, NYBuilt 1984 · S/N 15285852 N9514TColl Valdes Jeffrey A · Boise, IDBuilt 1978 · S/N 38-78A0122 N95159Kinne Dagmar · Woodburn, ORBuilt 1984 · S/N 15285860 N9518LAnkney Gary L · Rector, PABuilt 1976 · S/N AA1B0668 N9522TVeillon Joseph B · Alexandria, LAS/N 555 N9523UKpcw Grumman LLC · Port Clinton, OHBuilt 1977 · S/N AA1C0017 N9525TPorte Elvis · Miami, FLS/N 38-78A0125 N9525UBaloo Flight Holdings LLC · Peoria, AZBuilt 1977 · S/N AA1C0019 N9526UHart Lewis W DBA · Rexburg, IDBuilt 1977 · S/N AA1C0020 N9528URegistered aircraftBuilt 1977 · S/N AA1C0024 N952GSStiffler Gary C · Goshen, OHBuilt 1974 · S/N AA1B-0434 N9530URegistered aircraftBuilt 1977 · S/N AA1C0026 N9531UClarke Adam M · Lompoc, CAS/N AA1C0027 N9532URosenkranz James H · Garland, TXBuilt 1977 · S/N AA1C0028 N9534UDavis Allen J · Weidman, MIS/N AA1C0030 N95374Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285879 N9538UMoxom Jeremy · Raleigh, NCBuilt 1977 · S/N AA1C0035

Back to AD 80-25-02 R2