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.
N8941DMain David W · Blounts Creek, NCN8942DCwynar Scott L · Toledo, OHFirst renewal noticeN8942PAncelet Grant D · Crowley, LAN8944PPittner Hans C · Goshen, NYN8944YTallman Michael Daniel · Latrobe, PAN8945DSonnenberg Larry L · Huber Heights, OHN8945YPipers Are Still Better LLC · Carson City, NVN8946PBreding Ralph E · American Falls, IDN8947YStroh Chuck · Yukon, OKN8948YKilpatrick Kerry · Somerset, NJN894NDUnd Aerospace Foundation · Grand Forks, NDN8951DChadwick Stewart · Yuba City, CAN8951PJames Donnie E · Collinsville, ALN8952PBreckenridge Lester James Jr Trustee · Appleton City, MON8953DVassal Ministries · North Pole, AKN8953PTendie Time Flying LLC · San Diego, CAN8954DSandstead Russell L · Columbia, TNN8954PKramer Kartie K · Mckinney, TXN8955PPropwash LLC · Princeville, ILN8955YCarter Howard A III · Stafford, VAN8956YDark Side Aeronautical Inc · Wilmington, DEN8957PCreedon John · Mc Cormick, SCN8958DPoulton Daniel D · Belton, SCN8958PVan Dyke David M · Portland, ORN8959PMosel Properties LLC · Marrero, LAN895NDUniversity Of North Dakota · Grand Forks, NDN8961PRegistered aircraftN8962PDunning John · Stow, MAN8962YChoate Cass Joseph · Toone, TNN8963DDoyle Patrick H · Keller, TXN8963YNess Rent A Car Inc · Fargo, NDN8964DThomas Daniel C · Shady Shores, TXN8964PPerkins Michael W · Warren, MIN8965DSale Reported · Beech Creek, PASale reportedN8965PChancellor Richard · Palmer Lake, CON8965YLucid Thought Consulting LLC · Terre Haute, INN8966DDodd Robert L · Humboldt, IAN8966PLautensack Peter · Oswego, NYN8967YQualitair LLC Trustee · MichelstadtN8968DCleary Katherine E · Mulberry, FLN8969YTrident Aero Services LLC · Park City, UTN896NDUnd Aerospace Foundation · Grand Forks, NDN8970PPodraza Kevin M · Dekalb, ILN8971PDerrel Luce Pc · Waco, TXN8971YLaubscher John E · Cazenovia, NYN8972PHardy Douglas · Lakewood, CAN8973CUrbach Jourdan B · Sherman Oaks, CAN8973PBrockwell Derrell Randel · Oakland, TNN8973YAire Ryder LLC · Roseville, MNN8974P4papa LLC · Gig Harbor, WA
Back to AD 85-02-05 R1