AD 48-29-01

Registered aircraft · 374

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:48-29-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:48-29-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.

N4191KWells David M · Ada, MIS/N NAV-4-1191N4193KPrice Steven C · Midland, TXBuilt 1948 · S/N NAV-4-1193N4214KChristopher Michael L · Gerlach, NVBuilt 1948 · S/N NAV-4-1214N4224KDickson Robert T · Charlotte, NCBuilt 1948 · S/N NAV-4-1224N4230KHarper Paul V · Minerva, OHBuilt 1948 · S/N NAV4-1230N4242KNaviation LLC · Kalispell, MTBuilt 1948 · S/N NAV-4-1242N4244KKlungle William C · Grand Haven, MIBuilt 1948 · S/N NAV-4-1244N4251KVlahakis Gregory G · San Jose, CABuilt 1948 · S/N NAV-4-1251N4254KRankin Gary L · Meade, KSBuilt 1948 · S/N NAV-4-1254N4255KWheeler Douglas A · Mount Vernon, OHS/N NAV-4-1255N4262KBeaver Richard G · Spring, TXS/N NAV-4-1262N4264KBejvan David E · Milwaukee, WIBuilt 1948 · S/N NAV-4-1264N4267KStrength Vernon E · Eureka, CAS/N NAV-4-1267N4271KMoeding Michael M · Emporia, KSBuilt 1948 · S/N NAV-4-1271N4276KDunn Emet C III · Coolidge, AZBuilt 1948 · S/N NAV-4-1276N4278KUrubek Raymond L · Refugio, TXBuilt 1948 · S/N NAV-4-1278N4281KSperl Robert D · Keymar, MDBuilt 1948 · S/N NAV-4-1281N4286KDeemer Jerry C · Granbury, TXBuilt 1948 · S/N NAV-4-1286N4288KKrug III George R · Keller, TXS/N NAV-4-1288N4289KForsberg Edwin E · Elk Grove, CABuilt 1948 · S/N NAV-4-1289N4309KRezich James N · Winnebago, ILBuilt 1948 · S/N NAV-4-1309N4312KJorsey Allen Jr · Reidsville, NCBuilt 1948 · S/N NAV-4-1312N4317KEdwards Freeman Allen · Lake Butler, FLBuilt 1948 · S/N NAV-4-1317N4323KRothfleisch Joseph Ryan · Brawley, CABuilt 1948 · S/N NAV-4-1323N4328KSpringer Kelly · Edmonds, WABuilt 1948 · S/N NAV-4-1328N4336KWilliams 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-1342N4348KInman 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-1357N4362KNelson John A · Beverly, MABuilt 1948 · S/N NAV-4-1362N4371KAir 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-1386N4389KNext Aviation LLC · Evanston, ILBuilt 1948 · S/N NAV-4-1389N4390KCetacean Visions Films Inc · Santa Monica, CABuilt 1948 · S/N NAV-4-1390N4403KZiarniak 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-1421
Back to AD 48-29-01