OpenAirDocs.org
AD 81-23-03 R2

Registered aircraft · 421

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

N731TPHangar 28 LLC · Littleton, COBuilt 1980 · S/N P21000546N731XXGrimm John H II · Driftwood, TXBuilt 1980 · S/N P21000559N731ZBVanderwaal Shane J · Junction City, WIBuilt 1980 · S/N P21000565N731ZFTuggle James L Jr · Scottsdale, AZBuilt 1980 · S/N P21000566N732ETCaudill Jimmy L · Grove, OKBuilt 1980 · S/N P21000575N732RFWolvington Howard W · Genoa, NVBuilt 1980 · S/N P21000591N732RSAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N P21000592N732XHGwin Brandy L · El Lago, TXBuilt 1980 · S/N P21000596N732ZHDe La Porte Herb · Elyria, OHBuilt 1981 · S/N P21000599N7334PUp And Away Aviation LLC · Poughkeepsie, NYS/N P21000004N7346PIntegrated Avionics Services Inc · Hampstead, MDBuilt 1978 · S/N P21000007N734HW206 LLC · Portland, ORBuilt 1980 · S/N P21000602N734VSVitatoe Industries Inc · Chillicothe, OHBuilt 1980 · S/N P21000614N734WGStone Aviation LLC · Traverse City, MIBuilt 1980 · S/N P21000615N734WHObermeyer Keith · Excelsior, MNBuilt 1980 · S/N P21000616N7391PShph LLC · Edwards, ILBuilt 1978 · S/N P21000011N739MCaurus Power Inc · Santa Rosa, CABuilt 1978 · S/N P21000063N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279N7559KSkyway II LLC · Naples, FLS/N P21000410N7567KCutler Jeffrey R · Columbus, INBuilt 1979 · S/N P21000411N75LGMarr Lance · Portland, ORBuilt 1978 · S/N P21000015N75VRSlt Global Alliances LLC · Las Vegas, NVBuilt 1979 · S/N P21000429N75WFSjs Holdings LLC · Los Angeles, CABuilt 1980 · S/N P21000617N761BEAnderson Kristian L · Albuquerque, NMBuilt 1981 · S/N P21000660N767RFAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N P21000161N7711GTrans Meridian LLC · Fort Myers Beach, FLS/N P21000072N7736KValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000420N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276N77BVRegistered aircraftBuilt 1979 · S/N P21000221N77GSSouth Carolina Flyers LLC · Aiken, SCBuilt 1981 · S/N P21000613N77KRMarsh Aviation LLC · Old Lyme, CTBuilt 1981 · S/N P21000703N781DBCooper Roy · Lamesa, TXS/N P21000293N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583N800LGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000669N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081N85ADEagle Eye Produce Inc · Idaho Falls, IDS/N P21000795N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533N888ECArrow Aviation LLC · Noblesville, INS/N P21000076N888HFFlight1 Hsw LLC · Norwood, COBuilt 1981 · S/N P21000658
Back to AD 81-23-03 R2