AD 2012-03-52
Registered aircraft · 522
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:2012-03-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-03-52')
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:2012-03-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-03-52') 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.
N615PXKempton Robert · Tampa, FLN617DHChampionx LLC · Sugar Land, TXN618BLOrr Keith M Trustee · Portsmouth, NHN627HPRobinson Elizabeth R · Malibu, CAN627PMRichardson David J Trustee · West Memphis, ARN62GHBas Part Sales LLC · Greeley, CON62HWWestwind Holdings LLC · Wilmington, NCN62TFLinares Rafael · Palatine, ILN632PAN632pa LLC · Debary, FLN633GLRodine Dore N · Las Vegas, NVN634MCPlane Fun Inc Tr Trustee · Snellville, GAN63LJLj Marshall Enterprises LLC · La Mesa, CAN63TJAir & Sea Travel Fantasies LLC · Rutherford, NJN642CHPhoenix Leasing LLC · Menomonee Falls, WIN646ACZimmers Herbert J · Fox Point, WIN650DSFlight Crew Professionals LLC · Houston, TXN654ADTrull Robert Scott · Austin, TXN65PDVerhalen Flyers LLC · Marshall, TXN660DSJsk Flight Service LLC · Dallas, TXN665AGAircraft Guaranty Corp Trustee · Oklahoma City, OKN669WTLegacy Aviation LLC · Haddon Heights, NJN676JMDpe Services Inc · Des Plaines, ILN678JCJacs Adventures LLC · Conroe, TXN6792GGrimmett Donna G · Tomball, TXN67GXDivision Of Aerodynamics LLC · Littleton, CON6869LWeatherby Joseph III Trustee · Cuyahoga Falls, OHN688MDDiamond Aero Corp · La Quinta, CAN694KTSzentkuti Richard · Ridgefield, CTN698CMuehlstein Charles W · Stamford, TXN698PM88west Jet Sales LLC · Wisconsin Rapids, WIN6VWRegistered aircraftN700RTLipton Jack · Cottonwood, AZN705SEJones Hugh M · Locust Valley, NYN708BCCc Liaison Corp Trustee · Wilmington, DEN708PJKolasa Mark W · Washington, NCN711WJBeaubien Philippe R · Houston, TXN712NDAircraft Guaranty Corp Trustee · Oklahoma City, OKN718PTTechnology Transportation Co Inc · La Crosse, WIN71BFPlane Fun Inc Tr Trustee · Snellville, GAN721EMEuroaviation Inc Trustee · KematenN721PGKelly Site Development LLC · Durham, NCN721WMSoftcomm Aviation Inc · Irvine, CAN722FMA/C Airwaves LLC · Seattle, WAN728VMGuthrie Group Inc · Summerfield, NCN729MRFlanagan Brian F · Roseville, CAN72TFLeuthner Roger B · Albuquerque, NMN730MLRomeo Juliet Whiskey LLC · Saint Louis, MON745DLLambert Thomas · Grand Junction, CON750DBBearpack LLC · Boulder City, NVN750DCHills Alan · Youngsville, NC
Back to AD 2012-03-52