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.

N19976West Mi Shooting Alliance For Excellence In Safety · Marne, MIS/N 17702618 N19977Moody Matthew Joseph · Homewood, ALBuilt 1977 · S/N 17702619 N1997EOlsen Grain & Livestock Inc · Whitewater, MTBuilt 1978 · S/N 17271114 N1997RUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 1232-2026 N1997YMcculley Lowell Bruce · Front Royal, VABuilt 1964 · S/N 284 N1998Berwyn Cynthia K · Southaven, MSBuilt 1997 · S/N 2319 N19982Hayton James B · Sedro Woolley, WABuilt 1972 · S/N 17260909 N19983Twin Falls Fliers Inc · Twin Falls, IDBuilt 1972 · S/N 17260910 N19987Sprinz Steven B · Rimrock, AZBuilt 1972 · S/N 17260914 N19988Havener Ronald R · Overland Park, KSBuilt 1972 · S/N 17260915 N1998FSpartan Education Group LLC · Tulsa, OKBuilt 1998 · S/N 17280347 N1998LAyala Gerardo · San Antonio, TXBuilt 1976 · S/N M-1854 N1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 17280389 N19992United Manufacturing Inc · Holland, MIBuilt 1972 · S/N 17260917 N19996Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260919 N19997Neel Aviation LLC · Lakeland, FLBuilt 1972 · S/N 17260920 N1999PByler Dennis E · Wasilla, AKBuilt 1955 · S/N 22-2710 N1999QGentry Harry J · Canton, OHBuilt 1973 · S/N 177RG0399 N1999SVernon Margo L · Friendship, TNBuilt 1969 · S/N 32-1162 N1999TFly Boys Ink LLC · Ellington, CTFirst renewal noticeBuilt 1971 · S/N 28-7110024 N1999WWung Jay · Corvallis, ORBuilt 1986 · S/N 24-1564 N1999YToth Thomas I · Federal Way, WAS/N 286 N199AMVeterinary Imaging Solutions Inc · Davis, CABuilt 2002 · S/N 2201 N199ARBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 17274778 N199AVEcho Mike LLC · Baldwin, NYBuilt 1981 · S/N 28-8116283 N199BBennett Aviation LLC · New York, NYBuilt 2021 · S/N 3375 N199BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881956 N199CACapital Holdings 109 LLC · Potomac, MDBuilt 2005 · S/N 18281548 N199CBSmisek James W · Frankston, TXBuilt 1976 · S/N AA5A0226 N199DHDunn James · Fair Oaks, CABuilt 2005 · S/N 2215 N199DLClue Vista LLC · San Juan Capo, CABuilt 1997 · S/N 725 N199DPNoble Todd D · Hudson, INBuilt 1983 · S/N 981 N199ECRegistered aircraftBuilt 1999 · S/N 23982 N199GGFarris Clifford T · Acworth, GABuilt 2000 · S/N 002 N199GSHare Christopher W · Conroe, TXBuilt 2002 · S/N 5025 N199GWRaleigh Flying Club LLC · Chapel Hill, NCS/N 28-7990268 N199HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 3246126 N199JFlight For Diabetes LLC · Richmond, ILBuilt 1996 · S/N 006 N199JBOew Aviation LLC · Sumter, SCBuilt 1971 · S/N 28R-7135100 N199JCHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeBuilt 2006 · S/N 1031-2006 N199JFFronk Jan P · Provo, UTS/N 2 N199JTPena Rivera Luis A · Zephyrhills, FLBuilt 1960 · S/N 24-2323 N199LBL A B Flying Service Inc · Renton, WAS/N 790 N199MAEarles John F II · Bunkie, LABuilt 2013 · S/N 3180 N199MCFly N199mc LLC · Nevada City, CABuilt 1977 · S/N 17268570 N199MWWoftam Inc Trustee · Wilmington, DEBuilt 1979 · S/N 327940219 N199RAN199ra LLC · Huntington Woods, MIBuilt 1999 · S/N 18280636 N199RWRush Casey K · Troy, KSBuilt 1991 · S/N REW-01 N199SBertrand William R · Lubbock, TXBuilt 2000 · S/N 24831 N199SAWin Win Aviation Inc · Wake Forest, NCBuilt 2007 · S/N 1046-2007

Back to AD 81-18-04 R2