OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252N1277AWagner Tyler M · Sitka, AKBuilt 1951 · S/N 18-1072N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150N127826350 LLC · Yorklyn, DES/N 17702387N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261N1278ARegistration Pending · Palmer, AKRegistration pendingBuilt 1951 · S/N 18-1074N1278JBallester Alexis R · Mayaguez, PRBuilt 1975 · S/N 278N1278TSmith Sullivan · Cookeville, TNBuilt 1972 · S/N 28-7225447N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267N1279XRegistered aircraftBuilt 1963 · S/N 152N127AAnderson Eric H · Teaneck, NJBuilt 1975 · S/N 7-0109N127AKSwan Logistics LLC · Toledo, OHS/N 2059N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077N127BDRegistered aircraftBuilt 2022 · S/N 620-2022N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027N127CGRegistered aircraftBuilt 2025 · S/N 41976N127DMAircraft Leasing LLC · Peoria, ILBuilt 2017 · S/N 30023N127EYoung John C · Olathe, KSBuilt 2001 · S/N 2146N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797N127EMKrein Chris · Bismarck, NDS/N 121707N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481N127FRYoon Paul · Saint David, AZS/N 17275292N127GSSanoski Gregory G · Talkeetna, AKS/N 12-273N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532N127HHSoaring Fun Inc · Dover, DEBuilt 2017 · S/N 056/USN127JNNewman Jimmie L · Davenport, FLBuilt 2007 · S/N 24735N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210N127KJSky Flowers Holding Group LLC · Sunrise, FLS/N 10248N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827N127LFFisher Nicholis W · Springfield, LAS/N 27N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503N127PMinard Robert Myron Jr Trustee · Laveen, AZBuilt 1997 · S/N 24672N127PSParsa Aviation LLC · Boca Raton, FLS/N 6010N127RBushby Harvey M Jr · Minonka, ILBuilt 1995 · S/N M-II-1110N127SAVintage Tailwheel LLC · Wilmington, DEBuilt 2006 · S/N 1026-2006N127SHWaverly R22 LLC · Oklahoma City, OKBuilt 2007 · S/N 4116N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256N127TBenham Charles · Lorena, TXBuilt 1952 · S/N 18-2241N127TGEberle Brian J · Newnan, GABuilt 2005 · S/N 21321N127TZMeng-Hannan Construction Inc · Portland, ORBuilt 2000 · S/N 2108N127VATelkamp Gary O · Rapid City, SDBuilt 2003 · S/N 90127
Back to AD 81-18-04 R2