AD 53-08-01

Registered aircraft · 747

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:53-08-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:53-08-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.

N4336KWilliams Rae Alva · Elmore, ALBuilt 1948 · S/N NAV-4-1336N4338KGonzales Donald M · Columbia Station, OHBuilt 1948 · S/N NAV-4-1338N4339KBacon Jeffrey A · Gig Harbor, WABuilt 1948 · S/N NAV-4-1339N4341KRegistration Pending · Georgetown, OHRegistration pendingBuilt 1948 · S/N NAV-4-1341N4342KWatson William J · Somerset, KYS/N NAV-4-1342N4343KPoulin Eric A · Brownsville, TXBuilt 1948 · S/N NAV-4-1343N4346KMastalerz Peter W · Monson, MABuilt 1948 · S/N NAV-4-1346N4348KInman Dentis R · Medina, TNBuilt 1948 · S/N NAV-4-1348N4352KJed Homes Inc · Lisbon, CTBuilt 1948 · S/N NAV-4-1352N4355KDemaeyer Thomas · Punta Gorda, FLBuilt 1948 · S/N NAV-4-1355N4356KSimmons Andrew J · Meridian, MSBuilt 1948 · S/N NAV-4-1356N4357KAmerican Airpower Heritage Foundation Of Nm · Albuquerque, NMS/N NAV-4-1357N435CKrokosz Michael · Cottonwood, AZBuilt 1950 · S/N NAV-4-2167BN4362KNelson John A · Beverly, MABuilt 1948 · S/N NAV-4-1362N4368KMiller Robert H · Greenfield, INFirst renewal noticeBuilt 1948 · S/N NAV-4-1368N4371KAir Group 88 LLC · Charlottesville, VABuilt 1948 · S/N NAV-4-1371N4377KWilke Brian S · Arlington Heights, ILBuilt 1948 · S/N NAV41377N4382KSmith Dennis A Trustee · Salem, ORBuilt 1948 · S/N NAV-4-1382N4383KKaulback Edward C · Andover, CTS/N NAV-4-1383N4386KMachen Scott T · Tehachapi, CABuilt 1949 · S/N NAV-4-1386N4387KWings Of Hope · Chesterfield, MOBuilt 1948 · S/N NAV-4-1387N4389KNext Aviation LLC · Evanston, ILBuilt 1948 · S/N NAV-4-1389N4390KCetacean Visions Films Inc · Santa Monica, CABuilt 1948 · S/N NAV-4-1390N4394KSnyder Richard A · Fort Worth, TXBuilt 1948 · S/N NAV-4-1394N4403KZiarniak Michael · Palmyra, WIBuilt 1948 · S/N NAV-4-1403N4411KHiggins Michael H · Fairfield, PABuilt 1948 · S/N NAV-4-1411N4414KHoffman Ross M · West Point, GABuilt 1948 · S/N NAV-4-1414N4415KNavion Customs LLC · Chino, CABuilt 1948 · S/N NAV-4-1415N4416KMmj Group LLC · Abbeville, LABuilt 1948 · S/N NAV-4-1416N4417KBest Thomas A · Venice, FLS/N NAV-4-1417N4421KMartin Michael D · Ralston, WYBuilt 1948 · S/N NAV-4-1421N4423KDms Leasing Co LLC · Las Vegas, NVFirst renewal noticeS/N NAV-4-1423N4424KCiabattoni Joseph L · Hayden, IDBuilt 1948 · S/N NAV-4-1424N4425KPetersen Dennis B · San Luis Obispo, CABuilt 1948 · S/N NAV-4-1425N4428KDomingue Kevin · Spring, TXBuilt 1948 · S/N NAV-4-1428N4429KBurke Loren J · Snohomish, WABuilt 1948 · S/N NAV-4-1429N4430KLivingston Peter J · Ventura, CABuilt 1948 · S/N NAV-4-1430N4435KGlowaski Adam W · Mason City, IABuilt 1948 · S/N NAV-4-1435N4438KAdirondack Legacy Aircraft LLC · Saratoga Springs, NYBuilt 1948 · S/N NAV-4-1438N4439KKiller Contracting LLC · Wilmington, DEBuilt 1948 · S/N NAV-4-1439N443KKirst Forest M · Fairbanks, AKBuilt 1948 · S/N NAV-4-1436N4442KJudy Ronald W · Meade, KSBuilt 1948 · S/N NAV-4-1442N4443KClarke Richard W · Royal Oak, MDBuilt 1948 · S/N NAV-4-1443N4447KWiggins Charles R · Meridian, MSBuilt 1948 · S/N NAV-4-1447N4448KWoodside Andrew B · Bartlesville, OKBuilt 1948 · S/N NAV-4-1448N4449KHolder Todd · Madison, ALBuilt 1948 · S/N NAV-4-1449N444ACAmerican Airpower Heritage Fly Museu · Dallas, TXBuilt 1948 · S/N NAV-4-1463N444RBHeath David · Winona, MSBuilt 1950 · S/N NAV-4-2170BN4450KTomlin Rollin D · Wilmington, OHBuilt 1948 · S/N NAV-4-1450N4453KCurtis Derek E · Richmond, MOBuilt 1948 · S/N NAV-4-1453
Back to AD 53-08-01