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.
N7615KHardin Donald D · Kirkwood, MON7615PFly High Ventures LLC · Chester, VAN7616PNelson Peter T · Ghent, NYN7617DRunyan Colton C · Ashland, ALN7617PSlack Don S · Stinson Beach, CAN7618KGrabousky Chad T · Halifax, PAN7618PJaton Bertrand F · Woodville, TXN7619KNasby Kermit R · Shelbyville, INN7619PFirst Class Auto Remarketing LLC · Lehigh Acres, FLN7620KBarnes Thomas M · Pittsboro, NCN7621EGrey Matter Inc · Valley Springs, CAN7621PMckusick Eileen D · Winooski, VTN7622KCooper Kristopher A · Hamersville, OHN7623DBaker Donald A · Macedon, NYN7625PVfr2imc LLC · Elko, NVN7626KTopp Audrey · Reno, NVN7626PZervos Fredric W · Orland Park, ILN7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeN7627KEngwis Douglas R · Rhodes, MIN7627PKill Stephen W · Granbury, TXN7628KKrompacky Jozeph E · Talkeetna, AKN7628YLamantia Mark V · Ebensburg, PAN7629KLudwick Jacob W · Dunkirk, INN762ABPlane And Simple Leasing LLC · Delano, MNN762SUAlmost There Air LLC · Daytona Beach, FLN7630YJprg Aviation Inc · Orlando, FLN7631KOsborne Parker E · Minden, NVN7631YMbsp Enterprises Inc · Wilmington, DEN7632YLee Kitchell · Shelburne Falls, MAN7633YMatt Younkin Airshows Inc · Siloam Springs, ARN7634DRegistered aircraftN7634KParkhurst Brock · Harlowton, MTN7634PDykema Carl F · Davie, FLN7635KGrimes John A · Nevada City, CAN7636KBuergel Sandra J · East Aurora, NYN7637PFyi Adventures LLC · Ocala, FLN7638YScientific Motive Systems Inc · Charlevoix, MIN7639YCaviris Homestead Farm LLC · Rollinsford, NHN76400Horning Air LLC · Cresbard, SDN7641KEwert Gary P · Worthington, MNN7642PCollins Daniel R · Klamath Falls, ORN7643DDowling Matthew H · Clarksville, VAN7644DBeale David K · Tullahoma, TNN7644KKlauber Robert A · Athens, TNN7644PWhobrey Andrew · Bee Spring, KYN7645KRhoads Christopher A · New Castle, INN7645YN7645y LLC · Sheridan, WYN7646DBaier Warren R · Horicon, WIN7647KLee Andrew · Anchorage, AKN7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NY
Back to AD 85-02-05 R1