Registered aircraft · 1,016

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-01-R1') 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-01-R1') 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-01-R1')
    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-01-R1')
  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-01-R1')
  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-01-R1')
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.

N317JPTomlinson Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 4563 N3184PMarks Lloyd · Lafayette, LAS/N 45774 N3188PMarks Aviation Group LLC · Lafayette, LABuilt 1983 · S/N 45778 N3188ZFulton County Police Headquarters · Atlanta, GABuilt 1985 · S/N 3860 N3190PVeturis David · Lake Forest, CABuilt 1983 · S/N 45779 N3192G3192 Golf Inc · Wauchula, FLBuilt 1972 · S/N 809 N3196GUSA Helicopter Inc · West Winfield, NYBuilt 1972 · S/N 775 N31ATHelicopter Leasing Inc · Coral Gables, FLBuilt 1972 · S/N 918 N3202DPapa Mike Aviation LLC · Dousman, WIBuilt 1985 · S/N 3849 N3202QDavid Lee Aircraft Sales And Leasing LLC · Wilmington, DEBuilt 1986 · S/N 3938 N320CMDyvig Enteprises LLC · Northwood, IABuilt 1972 · S/N 836 N3211NTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1984 · S/N 3808 N321AWBolin William E · Smithville, OHBuilt 1967 · S/N 82 N322ECDivesa Aviation Services LLC · Missoula, MTBuilt 1977 · S/N 2218 N322NBlue Sky LLC · Anchorage, AKS/N 1507 N324CMClarke Environmental Mosquito Management · Roselle, ILBuilt 1977 · S/N 2303 N32AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45327 N32KYEnglish Air Service LLC · Santa Maria, CABuilt 1979 · S/N 2875 N331MHKt Auburndale LLC · Panama City Beach, FLBuilt 1982 · S/N 3564 N332MHXtreme Aviation LLC · Falkville, ALBuilt 1980 · S/N 2958 N333EROrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45203 N333FCGolden Ranch Aviation Inc · Raceland, LABuilt 1975 · S/N 1763 N333LWBohica Consulting Service Of Nevada Inc · Boulder City, NVBuilt 1980 · S/N 2932 N334KCHawk Hollow Farm LLC · Brighton, MIBuilt 1994 · S/N 4303 N335DMSmith Steven Lee · Whitehall, MTBuilt 1981 · S/N 3330 N337AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45383 N3399Scotts Helicopter Service · Le Sueur, MNBuilt 1968 · S/N 305 N33QPAir Metro Helicopter Inc · New City, NYBuilt 1979 · S/N 2753 N345RRChemair Helicopters Inc · Jefferson, WIBuilt 1977 · S/N 2107 N346ERCibaoair Aviation Group Inc · Middletown, DEBuilt 1995 · S/N 4337 N34AETrinkle Aviation LLC · Kingsburg, CABuilt 1979 · S/N 45218 N34CTCorporate Auto Brokers Inc DBA · Cleveland, GABuilt 2001 · S/N 4545 N34EWPlane Fun Inc Tr Trustee · Snellville, GAS/N 2108 N3521TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1979 · S/N 2703 N3523TMoreau Robert D · Granbury, TXBuilt 1979 · S/N 2637 N3528TR&B Helicopters Inc · Salinas, CABuilt 1981 · S/N 3516 N352MCCitrus County Mosquito Control District · Lecanto, FLBuilt 1973 · S/N 1131 N357MCHillsborough County Board Of County Commissioners · Tampa, FLBuilt 1995 · S/N 4355 N358HPMoe Dubois Excavating Inc · Shelburne, VTS/N 662 N358RLTopside Aviation Inc · Brasstown, NCBuilt 1979 · S/N 2736 N35RPB & B Investments Inc · Yucaipa, CAS/N 1431 N365JJtjl Leasing LLC · Cortez, COBuilt 2007 · S/N 4632 N368CBAero Leasing LLC · Virden, ILBuilt 1975 · S/N 1655 N36MKHorizon Helicopters Inc · Newark, DEBuilt 1974 · S/N 1360 N36MQRotor LLC · Dover, DEBuilt 1993 · S/N 4262 N376BTAppshle Air LLC · Long Beach, CABuilt 1979 · S/N 2767 N37AJL&R Investment Partners LLC · Wilmington, DES/N 1877 N382CAChem-Air LLC · Shreveport, LABuilt 1977 · S/N 2091 N382SPTag Aviation LLC · Casper, WYBuilt 1977 · S/N 2271 N386PZFast Boy Equipment LLC · Houston, TXS/N 407

Back to AD 81-18-01 R1