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.
N4052ZMetro Service Air · Fairbanks, AKN4053BCavenagh Thomas D · Lawton, OKN4053DGardner Dale R · North Logan, UTN4053FBluebird & Blue Skys LLC · St Simons Is, GAN4053TSky High Helicopters LLC · Camarillo, CAN4053ZSpohnholz Randy K · Anchorage, AKN40549Agnew Mark W · Wasilla, AKN4054BKing Ronald S Jr · Goldsby, OKN4054DBass Edward J · Richland, WAN4054GWorks Mark S · Cincinnati, OHN4054XLongmire Vaughn H · Tampa, FLN4054ZBiggs Craig P · Preston, IDN40552Peeler Jason B · Flooresville, TXN40558Hill Casey J · Anchorage, AKN4055DLoup Technologies Inc · Longmont, CON4055KHarris William R Jr · Salisbury, CTN4055NKansara Sanjay · Coopersburg, PAN4055XAtlas Air LLC · Salt Lake City, UTN4055ZMartin Lawrence M · Clam Gulch, AKN4056BTesar Thomas J · Williamsport, TNN4056MBarfield Anthur F · Fairborn, OHN4056SAvery Judy J Executor · Plainfield, ILN4056VHillsboro Aero Academy LLC · Hillsboro, ORN4056XHolliday Ralph C III · Coppell, TXN4056ZG & L Airborne Inc · Wilmington, DEN40575Evans Samuel F · Iuka, MSN40579Burwell Jeffery S · Wasilla, AKN4057BKaler Wayne J · Sayville, NYN4057CAberdeen Flying Service · Aberdeen, SDN4057NMominee Jules T · Evansville, INN4057SValley View LLC · Dover, DEN4057YWalther Newell A · Wasilla, AKN4057ZBruegger Shannon B · Lance Creek, WYN4058CHolt Tommy · Big Lake, TXN4058DKenley Douglas T · Palmer, AKN4058NHancock Randall G · Evanston, WYN4058XLeading Edge Aviation Foundation Inc · Mountain Home, ARFirst renewal noticeN40592Rml Aircraft Inc · Staunton, VAN4059BLyster Michael · Lake Havasu City, AZN4059MTcwh Inc · Hachita, NMN4059SKramer Harvesting LLC · Johnson, KSN405AArcher Aircraft LLC · Wilmington, DEN405ASJagadeesh Akhil V · Chicago, ILN405CACoast Flight Training And Management Inc · Dallas, TXN405CDLbi Aviation Corp · Manahawkin, NJN405CMHawaii Pacific Aviation Inc · Kailua Kona, HIN405CVCivil Air Patrol · Maxwell Afb, ALN405DSDelaware State University · Dover, DEN405DTSkiles Carl A · Leander, TXN405EFEagle Flying Club Of Embry Riddle Aeronautical · Daytona Beach, FL
Back to AD 2007-04-19 R1