AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N6841ASmooth Flying LLC · Barnwell, SCN6841HMckinney Steve R · Hamersville, OHN6841XNelson Ricky R W · Mandan, NDN6842FRodriguez Leyla M · Bellflower, CAN6843ECampbell Ronald M · Upland, CAN6843FMoyers John Jason · Midlothian, VAFirst renewal noticeN6843GTracey Corp · Midland, VAN6843XBoone Alan · Bangor, MEN6845EShores Kelly W · Thayer, ILN6845FHoward Donald E II · Ponca City, OKN6847AEwald Christopher Robert · Blanding, UTN6847FFranko Gregory · Grindstone, PAN6848FWhitehead Mathew S · Leesville, LAN6848XHinkleman Howard R · Brownsboro, ALN6849FDeangelis Jarrod A · Henderson, NVN6849HSmith Glenn W · Sheridan, WYN6849XReiss Alan T · Gig Harbor, WAN684JMThompson Joel L · Wichita, KSN6850ESchott Nicholas F · Burns, ORN6850GVoorheis Patrica D · Casa Grande, AZN6851FCarr Thomas W · Grand Blanc, MIN6852AFabian Ryan S · Vancouver, WAN6854ADulin Thad L · Midland, TXN6854ERowe Cecil D · Knoxville, TNN6854GUniverse LLC · Prospect, KYN6855ACowley Dale Thomas Trustee · Sandusky, MIN6856EHigh Plains Agronomics Inc · Milliken, CON6857GDuran Alexander · Holbrook, NYN68588Shipman Jared K · Bismarck, MON6858ACorrigan Flying Club · Manitowoc, WIN6858XHoang Andrew Q · Seal Beach, CAN68593Dunlap Russell Morgan · Palmer, AKFirst renewal noticeN6859AClark Brenton J · Fairfield, IAFirst renewal noticeN6859EAndersen Henrik T · Golden, CON6859XWilkerson Bradley W · Caldwell, IDN685RADenkat Plane Shadow LLC · Buckeye, AZN685WHMarmic LLC · Russell, KSN6861EBeckerman George F · Mount Carmel, ILN6862EBostik Industries LLC · Green Cove Springs, FLN6862FGradel Thomas A Jr · Irmo, SCN6863AZinter Dean K · Tigard, ORN6864ABrusik John A Jr DBA · New Port Richey, FLN6865ESustek Jerry · Seattle, WAN6865FGeissler Robert William Jr · Baltimore, MDN6865XGessley Lester Jack Jr · Port Saint Lucie, FLN68662Edwards Joseph C Trustee · Austin, ARN6866AJlk Inc · Malvern, ARN6866EStuart Bradley J · Hillsboro, NDN6866FLand Ross A · Cedar Rapids, IAN6867AHeffron Jacob L · Little Falls, MN
Back to AD 94-05-05 R1