AD 85-02-05 R1
Registered aircraft · 8,921
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.
N2033PAircraft Guaranty Corp Trustee · Oklahoma City, OKN2037PKuklo Robert M · Livermore, CAN203DMCsc Delaware Trust Co Trustee · Wilmington, DEN203SCWesley Robert J · Chuckey, TNN204SCGyure Ronald J · Fort Worth, TXN204WTRegistered aircraftN2050PDzvonik Eugen · Murray, UTN20540Baum Martin L · Bullard, TXN206ATAirline Transport Professionals Corp Of USA · Wilmington, DEN206RGVne LLC · Dowagiac, MIN2071PAviation Business Corp · Saint Louis, MON2079NSkywarrior Flight Training Inc · Pensacola, FLN2079WCoast Flight Training And Management Inc · San Diego, CAN2083DSale Reported · Crystal, MNSale reportedN2084ASunrise Aviation Inc · Ormond Beach, FLN2084PSchalk Bretta J · Fountain Run, KYN2089KBrown Frank J · Cold Spring, NYN208CAChristiansen Aviation LLC · Wilmington, DEN208RGInland Northwest Aero LLC · Veradale, WAN208SEJohn Stuart LLC · Miramar, FLN2090American Valet Air Inc · Wilmington, DEN2094CAnson Air LLC · Sugar Land, TXN2095KCalifornia In Nice Inc · San Jose, CAN2095PForbes Richard L · Plano, TXN2098PRegistration Pending · Granger, IARegistration pendingN209PTSilver Express DBA · Miami, FLN209SAInternational Air Services Inc Owner Trustee · Carson City, NVN20ALilbit Industries LLC · Oklahoma City, OKN20BUN20bu LLC · Champaign, ILN20DMLowe Aviation Co · Macon, GAN20JCJcmc Inc · Junction City, KSN20PPTullgren Michael · Lincoln, CAN20PRGunther Randell L · Chandler, AZN20PVPiper Aircraft Inc · Vero Beach, FLN20RDickerson Stephen R · Frisco, TXN2101AYork Harrison E · Aurora, CON2103ARooftop Aviation LLC · Westminster, MDN2104APittsburgh Institute Of Aeronautics · West Mifflin, PAN2105AStanistreet Ben · Anchorage, AKN2107AArcher Shafford R Jr · Norcross, GAN2108PGlover William S · Mount Pleasant, TXN210FLChristiansen Aviation LLC · Wilmington, DEN2111FDhs Operations LLC · Wilmington, DEN2112FBank Of Utah Trustee · Salt Lake City, UTN2112HAir V Inc Trustee · Wilmington, DEN2112PHardin John M · Terrell, TXN211TNScruggs Ken · Galloway, OHN2121AGitre Daniel J · Lakeview, MIFirst renewal noticeN21228Atp Aircraft 4 LLC · Wilmington, DEN2122AGubler Joseph A · Fairhaven, MA
Back to AD 85-02-05 R1