AD 84-10-01 R1
Registered aircraft · 20,481
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:84-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:84-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:84-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:84-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.
N7668ASpevacek William E · Geraldine, MTN7668KAviation Enterprises Aircraft Sales LLC · Springfield, MON766EETomaszewski John E · Oceanside, CAN766VNCagle Jonathan D · Mobile, ALN7672ATram Enterprises LLC · White, GAN7674KToms Robert G · Holly, MIN7678AHenderson William H Trustee · Eagle River, AKN767CACivil Air Patrol · Maxwell Afb, ALN767GEGreystoke Leasing Inc · Flagstaff, AZN767HRDg Upshaw LLC · Wilmington, DEN767KTStitch And Purl LLC · Sparks, NVN767LRegistered aircraftN767MTDouglas Machinery LLC · Saint Francis, SDN767RSRegistered aircraftN767WDLibby William J · Hooksett, NHN767XMNew Landing Aviation LLC · Yonges Island, SCN7680KStripe Joseph R · Olympia, WAN7680YMeekin Michael J · Palmer, AKN7681KNewberry Robert L · Lakeland, FLN7681UTunnel Electric Inc · Shingle Springs, CAN7684KWard Keven R · Juneau, AKN7685AAnderson Clarence D Trustee · Anchorage, AKN7685NFranklin Construction Inc · Chico, CAN7691DScout Aviation LLC · Homer, AKN7691GBorden John A · Hoover, ALN7698ABauman Jessica T · Junction City, ORN769BSWells Donald T · Seattle, WAN769DBLeblanc Alissa Walton · Dickinson, TXN76BLBravo Lima Corp · Lakewood, CON76BRKarban Edward W · Valley City, OHN76CNDensity Altitude LLC · Colorado Springs, CON76DACessna 76da LLC · Warsaw, VAN76DLSpur-N-Rotor Inc · Great Falls, MTN76EDFlying Hawks Ranch LLC · Bruning, NEN76HCHp Premier Solutions LLC · Lakeland, TNN76LGHeimbach Ann M · Duluth, MNN76LJNelson Flyers Inc · Louise, TXN76RCN76rc LLC · Buckeye, AZN76RFWeiman David W R · Oregon, WIN76RJMother Earth Flight Inc · Wilmington, DEN76RRReynolds Joseph I · Irving, NYN76TNC & D Aircraft LLC · Inver Grove, MNN76WGCooper David J Trustee · San Francisco, CAN7700HBrensing Steve E · Stafford, KSN7702KRose Hugh S · Fairbanks, AKN7707AGay Chris · Anchorage, AKN7708AFrelin Josef J · Anchorage, AKN770CFKopp Adrian D · Brookville, INN770HTailwind Aviation LLC · Huntingburg, INN7711AMckay Donald A · Soldotna, AK
Back to AD 84-10-01 R1