AD 2002-07-01

Registered aircraft · 3,466

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

N3976GBeauboeuf Andre F · Center Sandwich, NHBuilt 1967 · S/N U206-0976N397MSGregory Wm Broburg Ltd · Minneapolis, MNS/N 21061449N3987GParkhill Scott · Perrysburg, OHBuilt 1967 · S/N U206-0987N3989GJsh Farms Inc · Hermiston, ORS/N U206-0989N3992GFlat Earth LLC · Kalispell, MTS/N U2060992N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N39AKRenfro Michael W · Bethel, AKBuilt 1980 · S/N 20700597N39BEAberdeen Flying Service · Aberdeen, SDBuilt 1984 · S/N 21064889N3EM3em LLC · Karnack, TXBuilt 1981 · S/N P21000722N3KKKraussman Daniel J · San Antonio, TXBuilt 1978 · S/N 21062752N3KPAllied Asset Management LLC · Oklahoma City, OKBuilt 1981 · S/N P21000653N3LESubick Leonard W · Spring City, PAS/N 20700368N3PZBrothers Aviation LLC · Black Rock, ARS/N 210-63326N3UFAltorfer David W · Peoria, ILBuilt 1976 · S/N 21061410N400GTDelaney Holdings LLC · De Witt, IABuilt 1971 · S/N 21059544N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280N401SUWright Air Service Inc · Fairbanks, AKBuilt 1975 · S/N U20602932N402MPBravan Aviation Inc · Fort Lauderdale, FLS/N U20606896N403SWheeler James · Shreveport, LABuilt 1980 · S/N P21000403N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N410ABBloxsom Allan P III · Boerne, TXBuilt 1979 · S/N P21000352N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861N412TRoberts Gregory · Scottsdale, AZBuilt 1972 · S/N 21059558N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566N4194QJacques Jerry J · Iliamna, AKS/N U2061359N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872N41YYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 21063653N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040N4226QVolatile Aero Ventures LLC · Boulder City, NVBuilt 1976 · S/N U20603041N422BWBravo Whiskey LLC · Gilbert, AZBuilt 1968 · S/N 21059100N422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LABuilt 1979 · S/N U20605347N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164N4244SGolden Eagle Outfitters Inc · Delta Junction, AKS/N U20603814N424ADSky West Aviation Inc Trustee · Albuquerque, NMS/N 20700337N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590N4272QKeech Mark A · Fairbanks, AKBuilt 1976 · S/N U20603042N4291QRegistered aircraftBuilt 1976 · S/N U20603043N429DLLandset David J · West Palm Beach, FLBuilt 1975 · S/N 21060649N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667N433BPLeverock Richard C · Port Saint Lucie, FLBuilt 1981 · S/N P21000730N439DCLaguna Sky LLC · Wilmington, DES/N 21062636N43AKEarth Center Adventures Inc · Haines, AKBuilt 1980 · S/N U20605545N43CPMountain View Industries LLC · Missoula, MTBuilt 1979 · S/N P21000398N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563N43LSLima Sierra Inc · Nappanee, INS/N 21062124
Back to AD 2002-07-01