AD 96-09-08 R1
Registered aircraft · 130
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:96-09-08-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-09-08-R1')
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:96-09-08-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-09-08-R1') 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.
N105JPPittman Discover Flight LLC · Oshkosh, WIN110PSHartvigsen Thomas E · Winchester, TNN1191Vmc Aviation Inc · Upland, CAN12QWAll Aviation LLC · Tucson, AZN1326KPlane Fun Inc Tr Trustee · Snellville, GAN13KTButler Bryan C · Brenham, TXN14LPTherp Todd J · Rigby, IDN153GMFly High Aviation LLC · Melrose Park, ILN15WAG Force Aerobatics LLC · Eugene, ORN161JHAllison Daniel S Trustee · Jenner, CAN161PSBond Robert E · Knoxville, TNN161TCAkrotown USA LLC · Tualatin, ORN1643Elias Bernard J · Hampton, GAN1651NHartley John R · Bozeman, MTN169DMMost Toys Wins LLC · Joliet, ILN187PSMorrissey John C Col · Lees Summit, MON197TJSouthern Aircraft Consultancy Inc Trustee · Casper, WYN19HCVista I Inc · Smithville, OHN1ANConnelly Robert I · Blowing Rock, NCN1PWWelkin Aero Inc · Garden Plain, KSN203MCMac IV Aeroworks LLC · St Petersburg, FLN224TJJennings Herschel Todd · Stone Mountain, GAN245JHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN24FFHiemenz Thomas S · Westfield, INN252PSFields Joseph H · Placerville, CAN255PSSamani David L · Lincoln, NEN25CHPlanes Of Fame Air Museum · Chino, CAN25TCWoolslayer Homer J · Tulsa, OKN260CKSierra Lima LLC · Missoula, MTN260EFGiering Margaret J · Southampton, NYN260EJBrown Daniel A · Gettysburg, PAN260KAAntcliff Wayne E · Newport, WAN260LSSuter Lloyd Eugene · Apalachin, NYN260MJStoked Aero LLC · Camas, WAN260PAThompson Benjamin K · Nevada, TXN260PGTregeagle Richard D · Sandy, UTN260PRPlane Enterprises Inc · Martin, TNN260PSBulldawg LLC · Byers, CON260PWDuvall Garrett S · New Providence, PAN287PJWaterbury Craig A · El Paso, TXN28PBIpme Management Corp · Jefferson, GAN291PSInternational Air Services Inc Trustee · Carson City, NVN29KTManary Norman L · Rialto, CAN29RGHappy Raptor Flying Club LLC · Fort Lupton, CON300FAIcenogle Roger A · Inver Grove, MNN300WDPlane Fun Inc Tr Trustee · Snellville, GAN311PSRegistered aircraftN320PSMacon Lawrence T · Salisbury, NCN321MCAerospace Trust Management LLC Trustee · Wilmington, DEN331JRLeclercq Benoit B · Saint Cloud, FL
Back to AD 96-09-08 R1