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.

N687JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020087N687KBBoekelheide Kim · East Greenwich, RIBuilt 2002 · S/N 5687N687LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881266N687LPForgotten Heroes Foundation · Chesapeake, VAS/N 012N687MSScnicto LLC · Lewes, DEBuilt 2005 · S/N 82109N687NDAscent Aviation Inc · Duluth, MNBuilt 2014 · S/N 4496373N687RTFvx Research · Greenville, DEBuilt 2012 · S/N 18282350N687SPBmg Aviation Inc · Bloomington, INBuilt 1999 · S/N 172S8098N687SSSciscoe William D · Dish, TXS/N MB-675N687VRGriffin Larry W · Wynne, ARBuilt 2018 · S/N 74363N68806G&M Aircraft Inc · Wheat Ridge, COS/N 15282383N68808Mrb Aviation Inc · Lexington, SCBuilt 1978 · S/N 15282384N6880BAllmaras Donald P · New Rockford, NDBuilt 1956 · S/N 18-5067N6880NLawrence John J · Cypress, TXBuilt 1968 · S/N 680127N6880PBryant Michael E · West Chester, PABuilt 1960 · S/N 24-2016N6880VCraft Steven W · Port Saint Lucie, FLBuilt 1975 · S/N 20-1167N6880WRegistered aircraftBuilt 1965 · S/N 28-21036N6880ZMayes Brett R · Williams, CAS/N 25-2605N68810Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15282385N68812Avcorp Holdings Inc · Jackson, MIBuilt 1981 · S/N 15285339N68813Vogt Jeffrey D · Pleasant Grove, CAS/N 15282388N68814Spooner Wade G · Donalsonville, GABuilt 1978 · S/N 15282389N68815Skippy Aviation LLC · Bridgeport, PAS/N 15282390N68816Mirkovic Alex · Friendswood, TXBuilt 1978 · S/N 15282391N6881KTime 2 Fly LLC · Baldwinsville, NYBuilt 1979 · S/N 16-724N6881NMorris Michael R · Columbus, OHBuilt 1968 · S/N 680155N6881UElliott James C · Parker, COBuilt 1963 · S/N 2585N6881VCox Colin T · Harbinger, NCS/N 20-1168N6881WLewis Mark A · Ozark, ALBuilt 1965 · S/N 28-21037N6882PKrumel Bradley · Omaha, NEBuilt 1960 · S/N 24-2018N6882UHoecher Robert T · Anchorage, AKS/N 2586N6883BSlagle Allen E · Newcastle, WYBuilt 1956 · S/N 18-5070N6883JRobbins John L · Crossville, TNS/N 28-7615387N6883KDrb Helicopters LLC · Klamath Falls, ORS/N 16-726N6883NAj Mooney LLC · Port Saint Lucie, FLBuilt 1968 · S/N 680128N6883VHubbell Carl · Crowley, TXBuilt 1975 · S/N 20-1170N6883ZFoster Gary L · Palmer, AKBuilt 1964 · S/N 18-8136N6884HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265625N6884JHbk Flyers LLC · Alton, ILBuilt 1976 · S/N 28-7690420N6884KWyatt Mary Ellen Personal Representative · Weirsdale, FLBuilt 1949 · S/N 16-728N6884NLutes Kent A · Tazewell, TNBuilt 1968 · S/N 680157N6884USheaffer Bruce R Jr · Lititz, PABuilt 1963 · S/N 2588N6884VVan Dyck Ryan G · Talent, ORS/N 20-1171N6885HRasmussen Stewart · Santa Barbara, CABuilt 1975 · S/N 17265626N6885NPoskevich Douglas · Deland, FLBuilt 1968 · S/N 680158N6885UGranier Bernie C Trustee · Bandera, TXBuilt 1963 · S/N 2589N6885WMiller Andy D · Marana, AZS/N 28-21041N6886BOhmans Inc · Gillette, WYBuilt 1956 · S/N 18-5073N6886HParr Larry · Clarksville, TNBuilt 1975 · S/N 17265627N6886JFlanders David J · Madison, WIBuilt 1976 · S/N 28-7690421
Back to AD 81-18-04 R2