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.

N9511JGomez Alexandro · Riverside, CABuilt 1966 · S/N 28-3633N9511KMoore Matt R · Nashville, TNS/N 28-7625182N9511MBenjamin Joseph · Erie, COBuilt 1966 · S/N 670088N95121Preston Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28-25814N95122Mcnamara Kevin M Jr · East Aurora, NYBuilt 1984 · S/N 15285852N9512CDe Aviation Inc · La Porte, TXBuilt 1978 · S/N 28-7816487N9512DFerrell Alan B · Arlington, OHBuilt 1958 · S/N 22-6428N9512FGeorge'S Aviation Services Inc · Honolulu, HIBuilt 1998 · S/N 17280429N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190N9512JArapahoe Flight Club LLC · Colorado Springs, COBuilt 1966 · S/N 28-3634N9512LKreykes K Douglas · Greeley, COBuilt 1998 · S/N 18280237N9512MBible Larry · Mount Pleasant, TXBuilt 1966 · S/N 670089N9512SBlack Daniel L · Spicewood, TXBuilt 1965 · S/N 7GCBA21N9512UWilkes Jack M · Port Orchard, WAS/N 018N95133Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25818N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844N9513CAgri Business Aviation Inc · Sparta, ILBuilt 1978 · S/N 28-7890418N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191N9513JGlorioso Richard · Plant City, FLBuilt 1966 · S/N 28-3635N9513LMott Terry W · Hampton, IABuilt 1972 · S/N AA5-0213N9513MHangar9llc · Queen Creek, AZBuilt 1966 · S/N 670090N9513PAir Sailing Inc · Reno, NVBuilt 1974 · S/N 25-7405600N95147Ramirez Ricardo A · San Antonio, TXBuilt 1969 · S/N 28-25822N9514DAdams David D · West Ossipee, NHBuilt 1958 · S/N 22-6430N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192N9514JDu Bois Aviation Inc · Chino, CABuilt 1966 · S/N 28-3637N9514LBiller Mary Catherine · Columbus, OHBuilt 1973 · S/N AA5-0214N9514MHolen Benjamin E · Ketchum, IDBuilt 1966 · S/N 670091N9514TColl Valdes Jeffrey A · Boise, IDBuilt 1978 · S/N 38-78A0122N95151Gonzalez-Pinto Carmelo · San Antonio, TXBuilt 1969 · S/N 28-25823N95154Cen Inc · Sheridan, WYS/N 28-25825N95157Smutek Brian D · Mio, MIBuilt 1969 · S/N 28-25828N95159Kinne Dagmar · Woodburn, ORBuilt 1984 · S/N 15285860N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846N9515DElmer Charles F · Saint Clair Shores, MIBuilt 1958 · S/N 22-6439N9515JBowman Alex T · Virginia Beach, VABuilt 1966 · S/N 28-3638N9515KBoyd Matthew · Hudsonville, MIBuilt 1976 · S/N 28-7615209N9515MReid Stephen M · Gardner, KSBuilt 1966 · S/N 670092N95160Registration Pending · Lakewood Ranch, FLRegistration pendingBuilt 1969 · S/N 28-25829N9516FKelly David · Issaquah, WABuilt 1967 · S/N 170311N9516JEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280396N9516KSmith Dalton L Trustee · Smyrna, DEBuilt 1976 · S/N 28-7615210N9516MBurrell John Eric · Springfield, VABuilt 1966 · S/N 670093N9516WRingco Aviation LLC · Oklahoma City, OKS/N 18280226N95173First Flight Corporation · San Diego, CABuilt 1969 · S/N 28-25832N9517DLarson David R · Boerne, TXBuilt 1958 · S/N 22-6433N9517FS Martinez Livestock Inc · Moxee, WABuilt 1967 · S/N 170312N9517JBanks Brian H · Zebulon, GABuilt 1966 · S/N 28-3640N95181Stahl Jason R · Etters, PABuilt 1969 · S/N 28-25835N9518DJaugust Vladimir · Somerville, MABuilt 1998 · S/N 18280126
Back to AD 81-18-04 R2