AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5060GSpragues Aerial Spraying Inc · Courtenay, NDN5060JEeds Lucky L · Claude, TXN5060LVassilou Dimitri · Berwyn, PAN5060MBowden James Jr · Fairbanks, AKN5060RBristow Brent L · Anchorage, AKFirst renewal noticeN5060TAirzona Aircraft Services Inc · Kingman, AZN5060UPeoples Douglas A · Horseshoe Bay, TXN5060VMacair Aviation LLC · Xenia, OHN50615Stinger Tailwheel LLC · Miami, FLN50616Burge Kimberly · Wasilla, AKN50619Registered aircraftAssigned, pending cancellationN5061DKnight Frederick T · Arkadelphia, ARN5061GMoore David B · Wasilla, AKN5061KSchweiss Charles · Fairfax, MNN5061NGroth Matthew C · Arlington, WAN5061QLepper Michael J · Ward, CON5061TSullivan Patrick James · Avery, CAN5062CSchiegner Kyle Glen · La Mesa, CAN5062DRoberge Guy C · Westborough, MAN5062HCoati Aviation LLC · San Diego, CAN5062KBennett George III · Lambertville, NJN5062LSundial Getaways LLC · Santa Rosa Beach, FLN5062NSmith Julia P · Bedford, WYN5062PPiercy Ronald S · Moses Lake, WAN5062RRichland County Finance Department · Columbia, SCN5062UEnglish Ryan E · Henderson, NVN5062VLeiby John S · Frostproof, FLN50630Burnham William L · Lynchburg, VAN50633Sherwood Ronald R · Kathleen, GAN50636Placer Aviation LLC · Loomis, CAN50637Great Planes Aviation Inc · Rochester, MNN5063DIndian Ridge Ag Enterprises LLC · Pavillion, WYN5063EAdams James R · Prescott, AZN5063HParsons William L · Harrogate, TNN5063LVirga Aviation LLC · Virginia Beach, VAN5063QNorthern Hydraulic Dredge Co Inc · Harrisville, MIN5063SLancon James B · Prescott, AZN5063TKramer Ryan T · Hector, MNN5063VLatham David C · Weld, MEN5063WChampagne Patrick D · San Angelo, TXN5063YPlane Fun Inc Tr Trustee · Snellville, GAN5064CEaton Roger C · Vernon, NYN5064DPershing Flying Club Inc · Lovelock, NVN5064GCurran Joseph R · Eielson Afb, AKN5064HFranklin Air Services LLC · New Orleans, LAN5064URowe Timothy R · Texarkana, ARN5064VSenita Kent · Dublin, OHN5064WCmd Holding LLC · Fresno, CAN5064XHuber Bryan L · Jonesboro, ARN5065DWharton Edwin Scott · Anchorage, AK
Back to AD 2007-04-19 R1