Registered aircraft · 81,733

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.

N339DLFriedrich Robin K · Houston, TXS/N 90206 N339EEvans James W Jr · Wake, VABuilt 1985 · S/N 759 N339ECBlackmore Marc A · Hilltop Lakes, TXBuilt 1977 · S/N 20017 N339EZPico Andres V · Hollywood, MDS/N 1339 N339GOrsolits Robert M · Maitland, FLBuilt 2011 · S/N 361 N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119 N339MEShinkle Gordon · Gillette, WYBuilt 2000 · S/N 18280734 N339MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881097 N339NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2006 · S/N 28010012 N339PJWallace James R · Aumsville, ORBuilt 2006 · S/N 90589 N339RVBillips Robert A · Bluefield, VABuilt 2016 · S/N 92170 N339SABig River Farms Inc · Natchez, MSBuilt 1999 · S/N 18280508 N339SCSea Seven LLC · Weatherford, TXBuilt 2014 · S/N SC007 N339SPCahill Michael · Moon Township, PABuilt 2003 · S/N 172S9496 N339TLeroux Todd C · Palmer, AKBuilt 1953 · S/N 18-2453 N339WLawson Richard Brandon · Ararat, NCBuilt 2000 · S/N 5657 N33AKMoses And Associates Inc · Gainesville, FLBuilt 1980 · S/N 61P08508163448 N33ANBarnes Gary Aaron · Huntsville, ALBuilt 1993 · S/N 625-320-0370FB N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784 N33AVMaurer Sara Ann · Anchorage, AKBuilt 1996 · S/N 1332 N33AWWeigle Alan B · Seward, NEBuilt 2001 · S/N 489 N33BGifford Steven K · Buskirk, NYBuilt 1946 · S/N 12-784 N33BP33bp LLC · Sand Springs, OKBuilt 1992 · S/N 691-92 N33BYSellmeyer Flying Service · Knobel, ARBuilt 2005 · S/N 990-2005 N33CBShepperson Frank Lester · Midwest, WYBuilt 1958 · S/N 18-6682 N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989 N33CLBills Jacqueline Trustee · Willard, MOBuilt 1979 · S/N 28R-7918067 N33CMCharley Ernie · Gakona, AKBuilt 1976 · S/N 18-7609082 N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287 N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136 N33CXK & S Irrigation Inc DBA · Higbee, MOS/N 10569 N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451 N33DGStout Russell · Theodosia, MOBuilt 2012 · S/N 70168 N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4 N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176 N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70 N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182 N33EFJarosak Theodore J Jr · Portage, INBuilt 1985 · S/N 1345 N33ELAdvancing Blade LLC · Glenwood, MNBuilt 1992 · S/N 20770 N33ERCrump Edward J · Boonton, NJBuilt 1978 · S/N AA5B0884 N33ESDuncan Ernest Michael · Dripping Springs, TXBuilt 1976 · S/N 28R-7635461 N33FKMotis Joseph D · Huntington Beach, CABuilt 1970 · S/N 28-5763 N33FMAtp Aircraft 7 LLC · Wilmington, DEBuilt 2012 · S/N 172S11196 N33FUZeiset Karl D · Salmon, IDBuilt 1979 · S/N 241 N33GLJohnston Jeremy A · Cedar Springs, MIBuilt 1983 · S/N 532 N33GRHeadrick John Eric · Eolia, MOS/N 259-76 N33GSFish N Fly LLC · Hobe Sound, FLS/N 15281292 N33GVMilhous Richard J · Aguila, AZBuilt 2017 · S/N PETERSON 3 N33HParker Shon T · San Angelo, TXBuilt 1968 · S/N 28-11115 N33HARykris Investments LLC · Bowling Green, KYBuilt 2011 · S/N 18282279

Back to AD 81-18-04 R2