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.

N400GEFreeway Airport Inc · Mitchellville, MDBuilt 1981 · S/N 17275445 N400GFLively Joshua · Montague, MABuilt 1985 · S/N 32R-8613002 N400HA15 Corp · Lansing, MIBuilt 1970 · S/N 17701484 N400HG5sfcapital Holdings LLC · Newark, DEBuilt 2026 · S/N 1400 N400HVReilly Herbert V · Bloomingburg, NYBuilt 2006 · S/N 400 N400HWHotel Whiskey LLC · Sylvania, OHBuilt 1994 · S/N 739-95 N400JCRegistered aircraftBuilt 1965 · S/N 28-2121 N400JGParsons David E · Panama City Beach, FLBuilt 1969 · S/N 17701347 N400JRAirspeed Investments LLC · Springfield, TNBuilt 1982 · S/N 28-8316007 N400JSKing Canyon Buffalo Inc · Denver, COBuilt 1996 · S/N 1328 N400JWAirfleet Holdings LLC · Beverly Hills, CABuilt 1974 · S/N 28-7405276 N400KBArrowhead Circle Leasing LLC · Cedar City, UTBuilt 1997 · S/N 1234-97 N400LDreher Steve · Bettendorf, IABuilt 1967 · S/N 17700278 N400LBAutumn Crocus LLC · Cincinnati, OHS/N 30-1059 N400LMGoldberg Gary S · Rockville, MDBuilt 1991 · S/N 10061 N400MAPetersen Jacob R · Wasilla, AKBuilt 1978 · S/N 18-7809126 N400MJHaney Michael W · Tehachapi, CAS/N 23-1627 N400NEKisska Michael K · Long Beach, CABuilt 2003 · S/N 0040 N400RNGuirguis Samuel · Fort Myers, FLS/N US001 N400RUBell Jake T · Lexington, KYBuilt 2008 · S/N 2405 N400SDLeonard Tyler D · Newbury Park, CABuilt 1996 · S/N 3612 N400TDHardy Mikel · Twin Falls, IDBuilt 1968 · S/N 30-1708 N400UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020228 N400VVCarver Aero LLC · Muscatine, IABuilt 2001 · S/N 4496105 N400VWSpuza Dan D · Sanger, TXBuilt 1992 · S/N 681-92 N400WHHorrigan William Jr · Roxbury, CTBuilt 2001 · S/N 875-2001 N400WRBrown Jon R · Palm City, FLS/N 1 N4010BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1418M N4010YRegistered aircraftBuilt 2025 · S/N 30103 N4010ZDickey Livestock Inc · Mackay, IDBuilt 1963 · S/N 18-7961 N4011ASky Helicopters Inc · Desoto, TXBuilt 2025 · S/N 30107 N4011EFredericks Harry III Trustee · Woodland, CAS/N 1385 N4011LSmith Jeffrey S · Linden, MIBuilt 1978 · S/N 0825 N4011MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-2888 N4011PWelke Paul R · Beaver Island, MIBuilt 1958 · S/N 23-1486 N4011QKolb Michael J · Glenside, PABuilt 1977 · S/N 28R-7737059 N4012FNational 967.LLC · Rock Hill, SCBuilt 1976 · S/N 28-7725001 N4012MRhode Erik D · Farmington, MNBuilt 1947 · S/N 12-2889 N4012TStull Joshua S · Tacoma, WABuilt 1968 · S/N M-1119 N4012ZHronkin Jesse G · Palmer, AKBuilt 1963 · S/N 18-7963 N4013ERogers Twyla M · Windham, MEBuilt 1977 · S/N 18-7809018 N4013MCook Richard J II · Princeton, ILBuilt 1947 · S/N 12-2891 N4013REquipment Plus LLC · Culpeper, VABuilt 1990 · S/N 1430 N4013XN4013x LLC · Great Falls, MTS/N 5113 N4014EMoriarty Gerald Joseph · Anchorage, AKBuilt 1978 · S/N 18-7809019 N4014MWright James Henry · Brooksville, FLBuilt 1947 · S/N 12-2892 N4014PGriffing Flying Service Inc · Port Clinton, OHBuilt 1958 · S/N 23-1489 N4014XFournier Ronald A · San Diego, CAS/N 5114 N4015NHazel Consulting LLC · Dayton, NVBuilt 1968 · S/N 680159 N4015TBauries Brian W · Abilene, TXBuilt 1968 · S/N M-1122

Back to AD 81-18-04 R2