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.
N30CBMoyer Scott L · Southlake, TXN30DWilderness Aviation LLC · Kalispell, MTN312NMHks Aviation LLC · Tampa, FLN3178GBrandt Goetz K · San Jose, CAN3374GBangle Delbert F · El Cajon, CAN344JTedesco Fred A · Newport Beach, CAN36DSummer Winds II LLC · Lafayette, INN36WTrans Nevada Express Inc · El Centro, CAN3864Southern Aircraft Consultancy Inc Trustee · Casper, WYN3GGCampbell William J DBA · Santa Rosa, CAN4000GTomlin Rollin D · Wilmington, OHN4001KZahn Mark V · Sarasota, FLN4008KOlson Eric C · Seattle, WAN4012KKane Robert F · Wilton, CAFirst renewal noticeN4015KCarroll David A · Gibsonville, NCN4016KHatch David G · Clovis, CAN4020KMeinen Albert D · Troy, ILN4021KNorthwest Navion Inc · Arlington, WAN4026KWarbird Holdings LLC · Middletown, DEN4029KCampbelll William Jr T · Sand Springs, OKN4030KBurnett David Mark · Scott City, KSN4032KWeise David D · Lakewood, CON4037KByrne Sofia V · Merrimack, NHN4043KJackson Ian C · Rochester, NHN4045KCincy Warbirds LLC · West Chester, OHN4047KJed Homes Inc · Lisbon, CTN4080K80 Kilo LLC · Hammond, LAN4101KBravery Aviation LLC · Viburnum, MON4102KTomlin Rollin D · Wilmington, OHN4106KBriggs Dan E · Hayden, IDN4110KDdrl Holdings LLC · Missoula, MTN4111KMillar Charles R · Maricopa, AZN4124KOtt Dean R · Carrollton, OHN4126KNichols Jan L · Bonham, TXN4130KColvin Buster · Big Cabin, OKN4131KDarnall Lane · Harrisburg, NEN4132KJohnston William D · Visalia, CAN4134KOv-10 Bronco Association Inc · Fort Worth, TXN4135KBurlace Thomas J III · Aurora, CON4139KStone Jason · Wellington, KSN4142KHopkins Frank · Wilmington, DEN4143KDerickson Russell J · Lamberton, MNN4145KGerondale Gregory · Tulsa, OKN4146KHolmes Peter N · Spokane, WAN4150KTomlin Rollin D · Wilmington, OHN4156KLohse Charles R · Onalaska, WAN4158KHester Jesse S · Mclean, VAN4169KAndersen Nicholas · Logan, UTN4172KRegistration Pending · Lebanon, CTRegistration pendingN4179AWeaver Gary M · Morgantown, IN
Back to AD 53-08-01