OpenAirDocs.org
AD 66-19-02

Registered aircraft · 273

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:66-19-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:66-19-02')
  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.

N100BMarshall Xavier T · Carson, CAS/N 57114N1024Calgonaire LLC · Seminole, TXS/N 57425N12RFMckay Jonathan S · Chesapeake, VAS/N 21057612N12WDHamburg Jeffrey · Corsica, SDS/N 57480N141DMTurbo Inc · Flint, MIBuilt 1977 · S/N 21061806N157LMBaughman David · Jeffersonville, INBuilt 1961 · S/N 21057764N17ABBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 21057674N198PBolski Dariusz · Rancho Cordova, CABuilt 1960 · S/N 57319N198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 210-61063N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271N205NBAirmotive Service LLC · Brigham City, UTBuilt 1962 · S/N 205-0151N210AKMaxinkuckee Aviation LLC · Columbus, INS/N 21061627N210GNJackson Flying LLC · Siloam Springs, ARBuilt 1961 · S/N 21057803N210GTTeufel Gregory W · Lake Stevens, WABuilt 1961 · S/N 21057590N210JRSouthard Robert W · Elk City, OKBuilt 1959 · S/N 57017N210KCFluid Media Inc · Moscow, IDS/N 21061595N210NSNovember Sierra Aviation LLC · Oneill, NEBuilt 1960 · S/N 21057595N210PRShaw Ronald V · Edmond, OKS/N 64883N210RRBeasley Emmett C · Bixby, OKBuilt 1960 · S/N 57503N210TFAll About The Doodles Inc · Kirkland, ILS/N 21057793N210WKCorrado Christopher · Newton, NJBuilt 1960 · S/N 57088N210YYApr Aviation · Fresno, CABuilt 1960 · S/N 57408N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540N2300PNess Dana E · Chester, MTS/N 21057746N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563N24KWright Douglas J · Greenwood, INBuilt 1960 · S/N 57265N25JCAvg LLC · Chico, CABuilt 1959 · S/N 57008N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061N344KVLutz Gregory J · East Bridgewater, MABuilt 1960 · S/N 57470N3603YCarter Duane Lee · Madison, GABuilt 1962 · S/N 21058103N3740YOmg Air LLC · Okeechobee, FLBuilt 1964 · S/N 21058240N3825YAtlas Mining & Mechancial Inc · Beryl, UTBuilt 1964 · S/N 21058325N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075N455EDTurner James Glenn · Naples, FLBuilt 1962 · S/N 21058118N4567FPatterson Roland O · Semmes, ALBuilt 1960 · S/N 57314N467DHLopez Floyd W · Arroyo Seco, NMBuilt 1960 · S/N 57142N4702WFour Flying Fools LLC · Geneva, FLS/N 57532N48PMFreeman Robert G DBA · Baker, FLBuilt 1960 · S/N 57567N4BEMehrer Kelly · Apex, NCBuilt 1960 · S/N 57332N522LNomura Christopher · Riverside, CABuilt 1960 · S/N 57516N6394BPepitone David D · Santa Fe, NMS/N 57459N6501XFisher John P · Surprise, AZBuilt 1960 · S/N 57501N6506XBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57506N6507XBailey Scott D · Ione, CABuilt 1960 · S/N 57507N6510XSteinbroner Daniel J · Lawton, OKBuilt 1960 · S/N 57510N6515XDauenhauer Steven M · Springtown, TXBuilt 1960 · S/N 57515N6519XN5746u LLC · Dover, DEBuilt 1960 · S/N 57519N6520XKenton Onstad · Parshall, NDBuilt 1960 · S/N 57520N6521XNelson Scott W · Summerset, SDBuilt 1960 · S/N 57521
Back to AD 66-19-02