AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-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:85-02-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:85-02-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:85-02-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.
N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEN7263ZAnderson Daniel A · Overly, NDN7264YYogi Air LLC · Wadsworth, OHN7265Walker Teresa L · Enid, OKN7265PQuinlan John H · Claxton, GAN7266PGrover Donald G · Canby, ORN7269PBoucher Bobbi · Fredericksburg, VAN7272PMellema Tammo · Dalhart, TXN7272YToucan Aviation LLC · Bentonville, ARN7273PBrice Brandon Scott · Denver, CON7274PKeil Ronald B · Lapeer, MIN7275YCross John Benjamin · Lake Charles, LAN7277YDouble A Investments Inc · Rowland, NCN7279YChormicle James R · Littlerock, CAN727DSYso Noz LLC · Grandville, MIN727LFLanier Equipment Leasing LLC · Gainesville, GAN727RMMarkle Robert L Jr · Cranberry Township, PAN727TCSandpiper Air LLC · Dickinson, TXN7281PGuardian Peaks Airways LLC · Portland, ORN7281YGo For Flight LLC · Minneapolis, MNN7282ZSimmons Aviation Services LLC · Pawcatuck, CTN7286YReagan Scott Lllp · Mount Pleasant, SCN7287PTwo Dot Aircraft LLC · Kalispell, MTN7287ZQuality Aviation Inc · Marana, AZN7288YN7288y LLC · Manassas, VAN7289ZWerth John F · Hays, KSN728KKWeddle Stephen J · Phillips, WIN7290PFarmland Investments Inc · Mound City, MON7294PMcnamara Pa · Far Hills, NJN7294YTgaap Inc · Dover, DEN7296ZKolb Duane L · Bison, SDN7298ZShenandoah Valley Soaring Inc · Nellysford, VAN72999Huntington Roger · Galena, AKN72ABGlobe Motorcycles Ltd Inc · Pembroke Pines, FLN72CVMccullough Wayne L · Greenfield, INN72DNPostiglione Daniel · West Babylon, NYN72MWStaggs Austin · Cudjoe Key, FLN72SB72 Sierra Bravo LLC · Allegany, NYN7300DClendaniel Randon · Desert Hot Springs, CAN7300YAdriatic Holdings LLC · Cheyenne, WYN7301DGrant Cary · Cave Creek, AZN7302YJohnson Robert Daniel · Seabrook, TXN7303PWeisend Chad · Peru, INN7303ZSeminole Flying Soaring Inc · Clermont, FLN7304YN3024d LLC · Reno, NVN7305YRegistered aircraftN7306DJ S H Farms Inc · Hermiston, ORN7306KKutschera Thomas C · Youngsville, NYN7307DKnight Todd A · Grimes, IAN7307XZimmer Chris P · Upham, ND
Back to AD 85-02-05 R1