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.
N340PSPowell Lester E Jr · Savannah, GAN345DWAir Research Ca Inc · Torrance, CAN36MTLesko Brady · Lusby, MDN388PSDarrow Matthew J · Truckee, CAN42TWDavis Keith · Manchester, TNN434DMSmith Lester C Jr · Colleyville, TXN450GMMyers Shawn Lee · Rincon, GAN48BTMalone William · Mount Nebo, WVN48EWKucel Richard S · Dallas, TXN49335Van Cleave Raymond D · Kalispell, MTN494BEBig Ego Aerobatics Inc · Naperville, ILN49BROlmsted Aviation LLC · Santa Paula, CAN49LHTexas Pitts Partners LLC · Plano, TXN50ALCardon Benjamin P · Chubbuck, IDN514BDLepkowski Daniel P · Industry, PAN51STCnc Aerobatics LLC · Ada, MIN524MDStick N Rudder LLC · Kensington, NHN5327CTolleson Charles B Jr · Carpentersville, ILN5344JMark Aero LLC · League City, TXN5349XBegrow Adroaldo Dorivaldo · Gulf Shores, ALN5352EEvergreen Aviation & Space Museum & Captian · Mcminnville, ORN53LMEastern Stearman Inc Trustee · Leesburg, VAN555RLBorek Thomas J · Homestead, FLN56PSLeonard Paul N · Ewa Beach, HIN58DERichmond P Curt · Anna, TXN597TJJt Airshows · Slidell, TXN59KKWhite Pitts Inc · Wilmington, DEN5SGMaxwell Edward · Louisville, KYN6025LThille Nicholas M · San Luis Obispo, CAN603SBHats Off Aviation LLC · Draper, UTN6076JAtlantic Resources Of Miami Inc · Deland, FLN6079YWaller Stephen B · Fairhope, ALN6081UHutchings Zachary A · Clewiston, FLN60823Green Ethan H · San Antonio, TXN60827Buergel Sandra J · East Aurora, NYN6082UWifferdill Inc · Palm Bay, FLN6087EGuletsky Stephen W · Goshen, CTN6089UPlane Fun Inc Tr Trustee · Snellville, GAN60JLLeluc Jerome · Fort Worth, TXN61PSPitts Rock And Roll Inc Trustee · Wilmington, DEN62PSRegistration Pending · Wallace, CARegistration pendingN65PSEastern Stearman Inc Trustee · Leesburg, VAN6RYTracy David B · West Haven, UTN711SFFlying L Aircraft Inc · Fort Denaud, FLN719APPeros Dino · Pipersville, PAN71AH & J Airplane LLC · Wilmington, DEN71RZSmith John J · Middlefield, CTN727PSGardner Timothy J · Gardnerville, NVN73CFFredette Catherine · Beaverton, ORN74LSAerodyne Industires Corp · Elburn, IL
Back to AD 96-09-08 R1