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.

N4981ZSmith Carroll D · Ethel, LABuilt 1961 · S/N 22-8590 N49821Flying Vikings Inc · Hayward, CABuilt 1979 · S/N 15283520 N49824Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281342 N49827Angel Aviation Inc · Peoria, AZS/N 15281344 N4982EDevrnja Aero LLC · Knoxville, TNBuilt 1978 · S/N 17271686 N49837D&L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1978 · S/N 15281351 N4983FSkyventure Avaition LLC · Battle Creek, MIS/N 17273115 N4983GBrouillard Mark R · Avon, INBuilt 1979 · S/N 17273530 N4983LDecoster Vaughn A · Greenwood, ARBuilt 1967 · S/N 28-4358 N4983MMccray Todd · Saint Augustine, FLBuilt 1980 · S/N 15284497 N4983YCaprock Soaring Association · Lubbock, TXBuilt 1968 · S/N 25-4787 N4983ZKoerner Aviation Inc · Kankakee, ILBuilt 1961 · S/N 22-8592 N49848Linder Robert E Jr · Conway, ARBuilt 1978 · S/N 15281357 N4984FChuprinko John A · Centerburg, OHBuilt 1977 · S/N 14246 N4984JBluewater Airmotive Corp · Wilmington, DEBuilt 1968 · S/N 28R-30738 N4984PMoore Bruce W · Aledo, TXBuilt 1964 · S/N 27-588 N4984RGingrich Fredric D II · Indianapolis, INBuilt 1977 · S/N 28-7890047 N4984SLinair LLC · Lewes, DEBuilt 1970 · S/N 28R-35704 N4984TBoggs Investments Air Div LLC · Fredericksburg, VABuilt 1972 · S/N 28-7225302 N4984ZRegistered aircraftS/N 22-8593 N4985EAmar James E · Goodyear, AZS/N P245 N4985JEri-Aero Land Partners LLC · Flower Mound, TXBuilt 1968 · S/N 28R-30739 N4985TPope Donald R · Enid, OKBuilt 1972 · S/N 28R-7235167 N49862California In Nice Inc · San Jose, CABuilt 1978 · S/N 15281366 N49864Purkinje Ltd LLC · Wilmington, DEBuilt 1978 · S/N 15281368 N4986JMcelhiney Lance V · Harker Heights, TXBuilt 1968 · S/N 28R-30740 N4986LFarrah Gabriel E · Avon, CTBuilt 1967 · S/N 28-4361 N4986PLms Aviation LLC · Omaha, NEBuilt 1964 · S/N 27-590 N4986VBlake Larry Q · Cleveland, GABuilt 1981 · S/N 606 N4986ZAlbers William J · Sidney, OHBuilt 1961 · S/N 22-8594 N49872Eaglet Flight Operations Lp · Fort Worth, TXBuilt 1978 · S/N 15281373 N49878Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281377 N4987JFulco Jason E · Frisco, TXS/N 28R-30742 N4987NWhite Jake W · San Antonio, TXBuilt 1979 · S/N 2 N4987PRegion Flyers LLC · Valparaiso, INBuilt 1964 · S/N 27-591 N49886Boon Bradley A · Greenwood, WIBuilt 1962 · S/N 28-1010 N4988HBent James L Jr DBA · Palatine Bridge, NYS/N 18-1955 N4988LAnson Flyers Club Inc · Wadesboro, NCBuilt 1967 · S/N 28-4362 N4988SMosley Jerry · Las Vegas, NVS/N 13011 N4988YVan Kleek Steve D · Milford, IABuilt 1968 · S/N 25-4797 N49899Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281381 N4989JEastern Florida State College · Cocoa, FLBuilt 1968 · S/N 28R-30744 N498CCShephard Russell Steven · Gallatin, TNBuilt 1976 · S/N 28R-7635447 N498CFBosely Thomas L · Tavernier, FLBuilt 1998 · S/N 5678 N498CMRoberts Mark · Tecumseh, MIBuilt 2007 · S/N 82208 N498ECEllie Belle Aviation LLC · Marietta, GABuilt 2013 · S/N 41240 N498EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11603 N498FLOneforty LLC · Dover, DEBuilt 1971 · S/N 28-7125315 N498HPSafe Flight Ops LLC · Venetia, PABuilt 1998 · S/N 3246121 N498JBBriggs James D · Maryville, TNBuilt 2005 · S/N 90498

Back to AD 81-18-04 R2