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.

N922MKNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282195N922PBillester Stephen E M · Parker, COBuilt 1974 · S/N 271HN922PWWilliams Carlton M · Big Lake, AKBuilt 2025 · S/N 001N922TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280249N922TJBowar Gary R · Miranda, SDBuilt 2008 · S/N 503-2008N922WSWerth Jill · Canandaigua, NYBuilt 1973 · S/N 947-73N92303Herman M Flink Inc · Mount Dora, FLBuilt 1993 · S/N 3213061N92306High Wingers Inc · Racine, WIBuilt 1973 · S/N 17261557N92307Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261558N9230DTbo Enterprises Inc · Chippewa Falls, WIBuilt 1958 · S/N 22-6290N9230MPernick Kevin · Milford, IABuilt 1966 · S/N 1187N9230SSlominski Marcus A · Chapin, SCBuilt 1976 · S/N M-1791N9230TProctor Richard P · Statesboro, GAS/N 11095CN9230VCloud Surfing Aviation LLC · Costa Mesa, CAS/N 690062N9230WLorenti Anthony Charles · Meriden, CTBuilt 1967 · S/N 28-10898N9230YDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11505N92318Flitepro Inc · Murrieta, CAS/N 17261561N9231JLeetz Tom · Elgin, ILBuilt 1966 · S/N 28-3302N9231VShaffer Lawrence · West Des Moines, IABuilt 1969 · S/N 690050N92324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 17261562N9232BLaird Charles L · Adelanto, CABuilt 1958 · S/N 55032N9232GHarold H Bruner · Pinehurst, IDBuilt 1992 · S/N 19001CN9232JAdirondack Flying Club LLC · Rome, NYBuilt 1966 · S/N 28-3305N9232LLuquette Harley M · Abbeville, LABuilt 1971 · S/N AA1A-0132N9232RRogers Ricky R · Saint Francis, KSS/N 19003CN9232TSannella Joseph J · Missoula, MTS/N 19002CN9232VFerri Lawrence E · Lake Worth, FLBuilt 1969 · S/N 690056N9232WBarnum Eric E Trustee · Maumee, OHBuilt 1967 · S/N 28-10900N9233LGreen Samuel B · Clifton Park, NYBuilt 1971 · S/N AA1A-0133N9233MSlone Buddie M · Waynesburg, KYBuilt 1966 · S/N 1188N9233RBlash Gregory J · Corona, CABuilt 1978 · S/N R18200671N9233VRenner David C Jr · Belleville, ILBuilt 1969 · S/N 690063N9233WMount Up Aviation LLC · Kirbyville, MOBuilt 1967 · S/N 28-10901N9233ZCalmwinds LLC · Middletown, DEBuilt 1993 · S/N 3213062N9234ACruz Salvador A · Sumter, SCS/N 21001CN9234ELdg LLC · Kalispell, MTBuilt 1992 · S/N 14033CN9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232N9234MRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1966 · S/N 1189N9234WRutledge Brent E · Uvalde, TXBuilt 1967 · S/N 28-10902N9234ZIovanna Steven · Plymouth, MABuilt 1995 · S/N 2811041N92356Hub City Aviation Academy LLC · Lubbock, TXBuilt 1973 · S/N 17261567N9235CWilliams Patrick S · Saint Paul, MNBuilt 1978 · S/N 28-7890392N9235LKidd Jeffrey A · Norcross, GABuilt 1971 · S/N AA1A-0135N9235QInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N 3213072N9235SKaidor Jerome L · Hayward, CABuilt 1975 · S/N M-1727N9235VLott William F Jr Trustee · Oklahoma City, OKBuilt 1969 · S/N 690051N92362Yeakley Gary G · Ontario, CABuilt 1993 · S/N 19006CN9236CRudloff Uwe K · Lake Village, INBuilt 1978 · S/N 28R-7837181N9236EPorch Brock J · Philip, SDBuilt 1977 · S/N 7142CN9236HOptic Air LLC · Sioux Center, IABuilt 1975 · S/N 17266034
Back to AD 81-18-04 R2