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.
N7070YBean James P · Tulsa, OKN7071PNelson Harold G · Pendleton, ORN7071YJts Aircraft LLC · Rock Hill, SCN7072KElliott Troy D · Star, IDN7072PRegistration Pending · Kalispell, MTRegistration pendingN7073PPeavy Jason L · Waco, TXN7073ZVacaville Aero Services Inc · Williams, CAN7074KMayo Jesse J · Fairbanks, AKN7074YWsv Aero Inc · Wilmington, DEN7076PDevils Lake Aero Repair Inc · Devils Lake, NDN707AUPiper Aircraft Inc · Vero Beach, FLN707MABlue Line Aviation LLC · Smithfield, NCN7080POstmo Robert P · Wahpeton, NDN7081YHershey Everett D · Pantego, NCN7081ZNutmeg Soaring Association · Freehold, NYN70846Dc Aero LLC · Ramona, CAN7084KBien Bradley D · Crestview, FLN7084PFreeman Jet LLC · Cape Coral, FLN7084YArkadelphia Aircraft Services Inc · Jonesboro, ARN7085PFlyum LLC · Bay City, MIN7086PKirby Frank P Jr · Huntington, WVN7087YRegistered aircraftN-number assigned, not yet registeredN7087ZCochrane Aaron W · Lake Bronson, MNN7088PDerksen Ronald E · Xenia, ILN7089KMz Aviation LLC · Mason, OHN7089PElliott James Richard · Florence, ALN7089YReed Joellen A · Newborn, GAN7089ZAzskyad LLC · Avondale, AZN708AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN7090KUlibarri Christopher G · Abilene, TXN7090ZSales Joe H · Seminole, TXN7091YJudie Bear Air LLC · Bend, ORN7092PPaul Eric C · Grapevine, TXN7092ZHollister Soaring Center LLC · Hollister, CAN7093KMoyers Tommy E · Portland, ARN7093YMoore James S Trustee · Gray Court, SCN7093ZMid Continent Aircraft Corp · Hayti, MON7094PS & M Aviation LLC · South Boston, VAN7098KHensley Roger A · Rosamond, CAN7099KLach Richard · Weldon, CAN709HSRokaboka Ltd · Mount Ida, ARFirst renewal noticeN70GVWeidner Melvin · Elk Grove, CAN70PBFreeman David B · Liberty, NCN70TLAltitude Adjusters LLC · Cranford, NJN7101YN7101y LLC · Wilmington, DEN7103PRiegel Robert L · South Pasadena, CAN7104PHill Chester · Bakersfield, CAN7105PPruet Glen A · Richardson, TXN7106BSlaughter D Wayne · Farmsville, NCN7106DHarris & Associates Inc · Scottsdale, AZ
Back to AD 85-02-05 R1