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.
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
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.
N4336KWilliams Rae Alva · Elmore, ALN4338KGonzales Donald M · Columbia Station, OHN4339KBacon Jeffrey A · Gig Harbor, WAN4341KRegistration Pending · Georgetown, OHRegistration pendingN4342KWatson William J · Somerset, KYN4343KPoulin Eric A · Brownsville, TXN4346KMastalerz Peter W · Monson, MAN4348KInman Dentis R · Medina, TNN4352KJed Homes Inc · Lisbon, CTN4355KDemaeyer Thomas · Punta Gorda, FLN4356KSimmons Andrew J · Meridian, MSN4357KAmerican Airpower Heritage Foundation Of Nm · Albuquerque, NMN435CKrokosz Michael · Cottonwood, AZN4362KNelson John A · Beverly, MAN4368KMiller Robert H · Greenfield, INFirst renewal noticeN4371KAir Group 88 LLC · Charlottesville, VAN4377KWilke Brian S · Arlington Heights, ILN4382KSmith Dennis A Trustee · Salem, ORN4383KKaulback Edward C · Andover, CTN4386KMachen Scott T · Tehachapi, CAN4387KWings Of Hope · Chesterfield, MON4389KNext Aviation LLC · Evanston, ILN4390KCetacean Visions Films Inc · Santa Monica, CAN4394KSnyder Richard A · Fort Worth, TXN4403KZiarniak 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, WYN4423KDms Leasing Co LLC · Las Vegas, NVFirst renewal noticeN4424KCiabattoni Joseph L · Hayden, IDN4425KPetersen Dennis B · San Luis Obispo, CAN4428KDomingue Kevin · Spring, TXN4429KBurke Loren J · Snohomish, WAN4430KLivingston Peter J · Ventura, CAN4435KGlowaski Adam W · Mason City, IAN4438KAdirondack Legacy Aircraft LLC · Saratoga Springs, NYN4439KKiller Contracting LLC · Wilmington, DEN443KKirst Forest M · Fairbanks, AKN4442KJudy Ronald W · Meade, KSN4443KClarke Richard W · Royal Oak, MDN4447KWiggins Charles R · Meridian, MSN4448KWoodside Andrew B · Bartlesville, OKN4449KHolder Todd · Madison, ALN444ACAmerican Airpower Heritage Fly Museu · Dallas, TXN444RBHeath David · Winona, MSN4450KTomlin Rollin D · Wilmington, OHN4453KCurtis Derek E · Richmond, MO
Back to AD 53-08-01