AD 81-18-04 R2

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
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.

N601PEVcs Transportation LLC · Hampton, VABuilt 1977 · S/N 61P-0421-153N601PSCastle Rock Services LLC · Helena, MTBuilt 1999 · S/N 60001N601PTWf Aviation LLC · Bozeman, MTBuilt 1980 · S/N 61P07988063409N601PZSkyking Aviation Services LLC · Carson City, NVBuilt 1980 · S/N 61P08288163436N601RDPichon Dean M · Essex, VTBuilt 2001 · S/N 2981N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71N601RVFly Right LLC · Reno, NVBuilt 2003 · S/N 60325N601TGKenmore Crew Leasing Inc · Bellingham, WAS/N 28R-7235214N601TMMims Edwin T · Murphy, NCBuilt 2008 · S/N 6-5545N601TTAgee John M Trustee · Sunriver, ORBuilt 1991 · S/N 786N601VLBeal Mark E · Northwood, IABuilt 2009 · S/N 6-5093N601VSJireh Wings LLC · Las Vegas, NVS/N 2036LN601VVBilodeau Allan M · Lakeland, FLBuilt 2017 · S/N 6-5610N601XSSpainhower Craig · Lakeland, FLBuilt 2008 · S/N 6-5096N6020DDufreche David S · Sanger, TXBuilt 1956 · S/N 22-4673N6020F7l Air LLC · Franklin, TXBuilt 2006 · S/N 18281814N6020LJenkins David B · Hemet, CABuilt 1972 · S/N AA5-0120N6020PClark Katherine A · Spring, TXBuilt 1979 · S/N MC-653N6020QN6020q LLC · Jensen Beach, FLBuilt 1965 · S/N 3231N6020WBritton Jeffrey A · Accident, MDBuilt 1964 · S/N 28-20020N6021FB R S Leasing Inc · Wilmington, DEBuilt 2006 · S/N 172S10180N6021KRegistration Pending · Grand Forks, NDRegistration pendingBuilt 2006 · S/N 172S10181N6021MPark Rapids Avionics Inc · Park Rapids, MNBuilt 2006 · S/N 18281817N6021QR&L Aviation Inc · Philadelphia, PAS/N 3232N6021WA&C Aviation LLC · Lawrenceville, GABuilt 1964 · S/N 28-20021N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25N6022LIrving Donald J · Deland, FLBuilt 1975 · S/N 0712N6022PRegistered aircraftBuilt 1959 · S/N 24-1117N6022SAhlberg Merick D · Eagle River, AKBuilt 1979 · S/N M-2156N6022WDelgado Mario J · Baldwin Park, CAS/N M-2153N6023AKirkendall Shane O · Cedar Park, TXBuilt 1993 · S/N 14604N6023DBusta Daniel N · Los Angeles, CABuilt 1956 · S/N 22-4676N6023SChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 17281337N6023VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10198N6023XSytsma Douglas A · Canton, MIBuilt 1960 · S/N 1611N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130N6024DPunt Matthew L · Wasilla, AKBuilt 1956 · S/N 22-4677N6024EDhs Operations LLC · Wilmington, DEBuilt 2006 · S/N 172S10200N6024TDouglass Bruce · Conway, MABuilt 2006 · S/N 172S10202N6024WWhite Pelican LLC · Union City, TNBuilt 1964 · S/N 28-20024N60250Camelot Aviation LLC · Wilmington, DEBuilt 1969 · S/N 15070171N6025DMorgan Joel E · Mcalester, OKBuilt 2006 · S/N 18281830N6025WSocal Flights LLC · Simi Valley, CAS/N 28-20025N6026CPflueger Michael W · Scottsdale, AZBuilt 1978 · S/N R18200357N6026GAce Pdr LLC · Lewisville, TXS/N 2073N6026LDolan Kathleen M · Sunnyside, WABuilt 1972 · S/N AA5-0126N6026QKosmata Charles C · Mcpherson, KSBuilt 1965 · S/N 3234N6026SPhoneix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10206N6026ZAerodynamic LLC · Aurora, ORBuilt 2006 · S/N 172S10208N60279Tensco Inc · Twin Falls, IDBuilt 2006 · S/N 18281804
Back to AD 81-18-04 R2