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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4191KWells David M · Ada, MIN4193KPrice Steven C · Midland, TXN4214KChristopher Michael L · Gerlach, NVN4224KDickson Robert T · Charlotte, NCN4230KHarper Paul V · Minerva, OHN4242KNaviation LLC · Kalispell, MTN4244KKlungle William C · Grand Haven, MIN4251KVlahakis Gregory G · San Jose, CAN4254KRankin Gary L · Meade, KSN4255KWheeler Douglas A · Mount Vernon, OHN4262KBeaver Richard G · Spring, TXN4264KBejvan David E · Milwaukee, WIN4267KStrength Vernon E · Eureka, CAN4271KMoeding Michael M · Emporia, KSN4276KDunn Emet C III · Coolidge, AZN4278KUrubek Raymond L · Refugio, TXN4281KSperl Robert D · Keymar, MDN4286KDeemer Jerry C · Granbury, TXN4288KKrug III George R · Keller, TXN4289KForsberg Edwin E · Elk Grove, CAN4309KRezich James N · Winnebago, ILN4312KJorsey Allen Jr · Reidsville, NCN4317KEdwards Freeman Allen · Lake Butler, FLN4323KRothfleisch Joseph Ryan · Brawley, CAN4328KSpringer Kelly · Edmonds, WAN4336KWilliams Rae Alva · Elmore, ALN4338KGonzales Donald M · Columbia Station, OHN4339KBacon Jeffrey A · Gig Harbor, WAN4341KRegistration Pending · Georgetown, OHRegistration pendingN4342KWatson William J · Somerset, KYN4348KInman Dentis R · Medina, TNN4352KJed Homes Inc · Lisbon, CTN4355KDemaeyer Thomas · Punta Gorda, FLN4356KSimmons Andrew J · Meridian, MSN4357KAmerican Airpower Heritage Foundation Of Nm · Albuquerque, NMN4362KNelson John A · Beverly, MAN4371KAir Group 88 LLC · Charlottesville, VAN4377KWilke Brian S · Arlington Heights, ILN4382KSmith Dennis A Trustee · Salem, ORN4383KKaulback Edward C · Andover, CTN4386KMachen Scott T · Tehachapi, CAN4389KNext Aviation LLC · Evanston, ILN4390KCetacean Visions Films Inc · Santa Monica, CAN4403KZiarniak Michael · Palmyra, WIN4411KHiggins Michael H · Fairfield, PAN4414KHoffman Ross M · West Point, GAN4415KNavion Customs LLC · Chino, CAN4416KMmj Group LLC · Abbeville, LAN4417KBest Thomas A · Venice, FLN4421KMartin Michael D · Ralston, WY
Back to AD 48-29-01