Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N2102CGreat Northern Aircraft Inc · Griffith, INBuilt 1978 · S/N 28-7916130 N2102EBrooks Terry A · Shelby, NCBuilt 1978 · S/N 17271156 N2102PZima Aviation LLC · Huntington Beach, CABuilt 2004 · S/N 172S9594 N2102RLarosa Vincent · Asbury, NJBuilt 1969 · S/N 28-5461 N2102SJericho Air LLC · Hilton Head Island, SCBuilt 1979 · S/N 32R-7985085 N2102VGiovanini Terry L · Bozeman, MTBuilt 1954 · S/N 182663 N2102YDotzler Richard L Jr · Harlan, IABuilt 1979 · S/N 28-7911144 N21030Aircraft Management Group Inc · Honolulu, HIBuilt 1978 · S/N 28-7816529 N21035Hayes Bradley M · Grove, OKBuilt 1974 · S/N 17263890 N2103ARooftop Aviation LLC · Westminster, MDS/N 20-884 N2103JTaffet Jay · New Orleans, LABuilt 1978 · S/N 28-7911073 N2103MMontgomery William A · El Paso, TXBuilt 1977 · S/N 28R-7837066 N2103TIasco Flight Training Inc · Redding, CABuilt 2004 · S/N 17281205 N2103UCramm Raymond Eduard · Palmdale, CABuilt 2005 · S/N 18281660 N2103WGoold Michael D · Fort Worth, TXBuilt 1973 · S/N M-1450 N2103XBrandon Capital Group Inc · Leland, MIS/N 32-7940084 N2104APittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1952 · S/N 22-560 N2104HGrenier Chad · Moorpark, CABuilt 2007 · S/N 172S10432 N2104NHammond Brian R · Lincoln University, PABuilt 1979 · S/N 28-7990271 N2104TAllison Jack A · Orangevale, CABuilt 1971 · S/N 28R-7135048 N2104UVeracy Aviation LLC · Arlington, VABuilt 1979 · S/N 28-7990327 N2104WMorgan Austin T · Henderson, NVBuilt 1973 · S/N M-1444 N21052Registered aircraftN-number assigned, not yet registeredS/N 28-7916023 N21056N21056 LLC · Wayne, PABuilt 2007 · S/N 172S10434 N2105AStanistreet Ben · Anchorage, AKS/N 20-889 N2105QBarreto Daniel · Enterprise, ALBuilt 1974 · S/N 177RG0505 N2105THolt Dennis A · Gilbertsville, PABuilt 1971 · S/N 28R-7135051 N2105UPiper Automotive & Marine Service Inc · North Miami, FLBuilt 1979 · S/N 28-7990328 N2105WNenow William R · Tulare, CABuilt 1973 · S/N M-1433 N2105XAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12585 N21065Omni Management LLC · Decatur, ALS/N 28-7990033 N2106CRunde Dean G · Riceville, IAS/N 28-7916131 N2106WGemma Aviation LLC · Duncan, SCBuilt 1973 · S/N M-1474 N2107AArcher Shafford R Jr · Norcross, GABuilt 1952 · S/N 20-887 N2107DBreslow Arnold M · Dania, FLBuilt 1978 · S/N 28-7916142 N2107EFly Kilo Charlie LLC · New Century, KSBuilt 1978 · S/N 28-7916162 N2107GMerkle Betty Lou · Hanover, ILBuilt 1978 · S/N 28-7911068 N2107UFlight World Inc · San Juan, PRBuilt 2004 · S/N 172S9603 N2107VEveritt Fred Jr · Henryville, INBuilt 1979 · S/N 28-7911127 N2107WIguana Aviation LLC · Chicago, ILBuilt 1973 · S/N M-1437 N2108CMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7990142 N2108ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271159 N2108HWise Charles · Bridgewater, MAS/N 28-7911053 N2108LSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2004 · S/N 172S9605 N2108PGlover William S · Mount Pleasant, TXBuilt 1956 · S/N 23-698 N2108VFast And Slow To Go LLC · Dover, DEBuilt 1979 · S/N 28-7911128 N2108ZPinnacle Aviation Services Inc · Encinitas, CABuilt 2004 · S/N 17281207 N2109BSchilling Aviation LLC · Britton, MIBuilt 1948 · S/N 6536 N2109LCaban-Loperena Jumil · Moca, PRBuilt 2004 · S/N 172S9609 N2109NStallings Farms Trucking LLC · Hertford, NCBuilt 1979 · S/N 28-7990274

Back to AD 81-18-04 R2