OpenAirDocs.org
AD 2004-21-08 R1

Registered aircraft · 511

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

N3765GGraber Quinten R · Brooksville, MSBuilt 1948 · S/N 7101N3868VSwift Stephen D · Flower Mound, TXBuilt 1949 · S/N 7329N3873VAthens Air LLC · Athens, TNBuilt 1949 · S/N 7335N3877VPetersonrandy · Sonoma, CABuilt 1949 · S/N 7339N3884VMather Todd A · Huron, OHBuilt 1949 · S/N 7353N3890VInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 7361N3891VKilo Aviation LLC · East Peoria, ILBuilt 1949 · S/N 7362N3893VSorenson Bennett L · Wichita, KSBuilt 1949 · S/N 7365N3894VHighland Thomas Eugene · Portland, ORBuilt 1949 · S/N 7366N3898VAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1949 · S/N 7376N3899VMagers Starla · Blessing, TXBuilt 1949 · S/N 7377N4024AEling Stefan · Savannah, GAS/N 7821N4051AVintage Sky LLC · Trussville, ALBuilt 1949 · S/N 7318N4306NWesner Robert F · El Reno, OKBuilt 1948 · S/N 7104N4310NMilton William H · Amsterdam, NYBuilt 1948 · S/N 7100N4310VRobertson Nathan M · Acworth, GABuilt 1948 · S/N 7217N4311NSchafhausen Mark G · Spokane, WABuilt 1948 · S/N 7099N4312NBarron John L · Perry, MOBuilt 1948 · S/N 7098N4318NBybee James W · West Jordan, UTBuilt 1948 · S/N 7092N4319VBarron Jon M · Perry, MOBuilt 1948 · S/N 7226N4323NGrant Yeol D · Livermore, CABuilt 1948 · S/N 7086N4323VRhodes John D · Tarzana, CAS/N 7316N4324NLeighton George E · Seattle, WABuilt 1948 · S/N 7085N4327VFultz Andrew J · Starkville, MSBuilt 1948 · S/N 7270N4328VLumcavok Aviation 1 Inc · Middletown, DEBuilt 1948 · S/N 7234N4329NPulver Douglas A · Kenockee, MIBuilt 1947 · S/N 7080N4330NMays Kevin E · West Liberty, KYBuilt 1947 · S/N 7079N4331NThomsen Consulting Inc DBA · Monee, ILBuilt 1947 · S/N 7078N4332VKenaga Michael L · Downers Grove, ILBuilt 1948 · S/N 7238N4334NHardy John A · El Paso, TXBuilt 1947 · S/N 7075N4335VMartin Edward I · Trinity Center, CABuilt 1948 · S/N 7241N4336NKrcma William H · Washburn, WIBuilt 1947 · S/N 7073N4337NAlldredge Aviation · Auburn, WABuilt 1947 · S/N 7072N4339VColtrin Christopher S · Schaumburg, ILBuilt 1948 · S/N 7245N4344NHernden Mike · Rockford, ILBuilt 1947 · S/N 7065N4344VBarron Aviation LLC · Perry, MOBuilt 1948 · S/N 7250N4346NJohnson Fredrick S Jr · Shelbyville, KYBuilt 1947 · S/N 7063N4346VKoberg Lance L · Dallas, GABuilt 1948 · S/N 7273N4347VSilver Cessnas LLC · Cheyenne, WYBuilt 1948 · S/N 7256N4350VAeroclassics LLC · Waynesboro, VABuilt 1948 · S/N 7259N4351VVandevort Lynn A · Manitowoc, WIBuilt 1948 · S/N 7260N4352NJantzen Ronald L Trustee · Porter, OKBuilt 1947 · S/N 7055N4352VRobertson Jon P · Acworth, GAS/N 7261N4353NEnea Donald J · Thompson, OHBuilt 1947 · S/N 7054N4357NDavis Charles H Jr · Manchester, MIS/N 7058N4357VRodriguez Daniel Lee · West Linn, ORBuilt 1948 · S/N 7266N4358VBloch Christopher P · Grand Rapids, MIS/N 7274N4366VKopf Edward H Jr · Las Vegas, NVBuilt 1948 · S/N 7281N4367NMajerle Joseph III · Anchorage, AKBuilt 1947 · S/N 7039N4367VGreulich Kenneth R Trustee · Sand Springs, OKBuilt 1948 · S/N 7282
Back to AD 2004-21-08 R1