AD 96-10-01 R1
Registered aircraft · 8,138
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-10-01-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-10-01-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-10-01-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-10-01-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.
N32258Wing Rentals LLC · Phoenix, AZN32265Norsesian Brandon · Valrico, FLN32271Tylka Edward · Lockport, ILN32274Simaan Daniel · Fontana, CAN32293Stone James B · Springfield, VAN32296Fly South Aviation LLC · Charlotte, NCN32314Fort Dodge Flight Support Inc · Fort Dodge, IAN3231QCollins Gregory J · Appleton, WIN32326Blair James J Jr · Brick, NJN32336Simmer Nicholas Lee · Rock Falls, ILN32355Finlayson Duncan Robert · Estacada, ORN32361Odom Eric J · Johnson City, TNN32369Avia Flight Academy LLC · Stratford, CTN32378Sanders David D · Alvin, TXN32386Rice Craig W · Walnut Creek, CAN32387Mclelland Brenda M · Springfield, MON32392Devrnja Aero LLC · Knoxville, TNN32397Tanya Austin L · Newburgh, NYN323BETracy Brian R · Georgetown, OHN323JMDubbert Roger D · Mexico, MON32405Hop-Hi Aviation LLC · St Louisville, OHN32413Peterson Paul · Maryville, TNN32419Registered aircraftN32426Fly Aviation LLC · Sabetha, KSN32435Nickos Ryan L · Kenosha, WIN32436Townsend Ricky E · Rogers, ARN32441Registration Pending · Kalispell, MTRegistration pendingN32466Oh Heung Taeg · Olney, MDN32475Eikenberry Don A · Palouse, WAN32480Alphakiloecho LLC · Somerville, MAN32500Fairfield Flying Service Inc · Fairfield, IAN32505N83at LLC · Dover, DEN32506Schuhler Louis A · Plainfield, ILN32514Summit Flight Academy LLC · Peculiar, MON32525Willaford Gina T · Cape Coral, FLN32526Cannon Adam H · Purcell, OKN32534Bh534 LLC · West Hartford, CTN32539Orosz Ryan · Santa Clara, CAN32540Registration Pending · Mocksville, NCRegistration pendingN32544Swaz Aviation LLC · Mesa, AZN32551Gcbc LLC · Norman, OKN32556Mcguire Richard L · Valparaiso, INN325925niner2 Aviation LLC · Washington, DCN32627Joyner Hudson Ellis · Memphis, TNN3263PSalazar Ralph T Jr · Leesville, LAN32646Russell Thomas Carl · Beverly Hills, FLN32653Emerald Flyers LLC · Everett, WAN32684Registration Pending · Brooks, GARegistration pendingN32692Holland Walter E Trustee · Casa Grande, AZN326MMHarrington James G · Westport, MA
Back to AD 96-10-01 R1