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.

N490DLWhidden William L · Lake Wales, FLBuilt 2012 · S/N 232 N490EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12258 N490GRWarnock Tony J · Mobile, ALS/N 97 N490LLAntel Av Corp · Lewes, DEBuilt 2004 · S/N 18281432 N490NWGalvin Flight Services Hawaii LLC · Honolulu, HIBuilt 2021 · S/N 172S12757 N490RRegistered aircraftBuilt 1999 · S/N 490R N490RVSmith William R · Seneca, PABuilt 2008 · S/N 20090 N490SPSky Training LLC · West Milford, NJBuilt 1998 · S/N 172S8031 N49105Carlyle Properties LLC · Columbia Falls, MTS/N 203 N4910BCooper Ronald C · Fowlerville, MIBuilt 1979 · S/N 15283702 N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394 N4910JGyure Ronald J · Fort Worth, TXBuilt 1968 · S/N 28R-30629 N4910LPeake Alexander · Tacoma, WABuilt 1967 · S/N 28-4275 N4910PWilkens Jacob James · Eagle River, AKBuilt 1962 · S/N 18-7832 N4910SMarden John E · Oakland, MEBuilt 1980 · S/N R18201449 N4911FFreed Michael L · Sylmar, CABuilt 1976 · S/N 28-7725035 N4911LMccown Brian W · Janesville, CABuilt 1967 · S/N 28-4276 N4911XLake Superior Helicopters LLC · Duluth, MNBuilt 2006 · S/N 1675 N4911ZSamson Robert L · Phoenix, AZBuilt 1961 · S/N 22-8496 N49120Aviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283425 N49123Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 15281152 N49125Morey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283426 N49126Flight Expo Inc · Princeton, MNS/N 15283427 N4912FNab LLC · Wichita, KSBuilt 1976 · S/N 28-7715079 N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459 N4912SStevens Joel N · Monticello, ARBuilt 1980 · S/N R18201451 N49138Osborn Scott R · Rch Palos Vrd, CABuilt 1979 · S/N 15283430 N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395 N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460 N4913LHaven Mark · Springfield, TNBuilt 1967 · S/N 28-4278 N49142Zion Summit Holdings LLC · Wesley Chapel, FLBuilt 1977 · S/N 15281161 N49144Westfall Benjamin C · Coeur D Alene, IDBuilt 1977 · S/N 15281163 N4914FCb N4914f LLC · Coventry, CTBuilt 1976 · S/N 28-7715080 N4914LWallace Aviation Inc · Wallace, NEBuilt 1967 · S/N 28-4279 N49150Skytrain Aviation LLC · Sumner, ILS/N 15281167 N49151Zhang Victoria · Daytona Beach, FLBuilt 1979 · S/N 15283432 N49159Comer Jacob W · Troy, MOBuilt 1977 · S/N 15281172 N4915JFox Richard A · Boynton Beach, FLBuilt 1968 · S/N 28R-30634 N4915LRoss Robert J · Landisville, PABuilt 1967 · S/N 28-4280 N4915PAubry Nicolas L · Port Jefferson, NYBuilt 1981 · S/N 15284840 N4915ZPamment Melvin M · Arlington, KYBuilt 1961 · S/N 22-8501 N49161Rohan Gerard K Sr · Marion, WIBuilt 1978 · S/N 15281174 N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463 N4916JRegistration Pending · Townsend, GARegistration pendingBuilt 1968 · S/N 28R-30635 N4916LMl Monkeybar Inc · Mammoth Lakes, CABuilt 1967 · S/N 28-4281 N4916PPiper Aviation Museum Foundation · Lock Haven, PABuilt 1962 · S/N 27-506 N4916TArithansa LLC · Big Bear City, CABuilt 1972 · S/N 28-7225281 N4917AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496254 N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464 N4917JTendall Timothy A · Sudbury, MABuilt 1968 · S/N 28R-30637

Back to AD 81-18-04 R2