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.
N2753WGleaton Marcus H · Weatherford, TXN2753XStorer Charles E · Payette, IDN2754EGulf Coast Helicopters Inc · Pearland, TXN2754FOtter Mark E · Warrensburg, MON2755BBoyce Aviation Inc · New Port Richey, FLN2755CR & B Aviation LLC · Oakland, MIN2755QBlessed With Wings LLC · Queen Creek, AZN2755WEast Rick · Muscle Shoals, ALFirst renewal noticeN2755XMcsheehy James B · Fallbrook, CAN2755YNancy Aviation LLC · Fayston, VTN2756JSquatch Air LLC · Wasilla, AKN2756QLett Brian R · Eden Prairie, MNN2756WJohnson Stephen C · Lake Tapps, WAN2757FNationwide Web Directory Ltd · Seattle, WAN2757MHaring Clay · Lincoln, KSN2757QFive Seven Quebec Incorporated · Lake Stevens, WAN2757WDennis Christopher A · Richardson, TXN2758Panair Flying Club Inc · Miami, FLN2758TLinn Anthony B · Westborough, MAN2758XAerotechniques LLC · South Kent, CTN2759ARichards Thomas D · Saint Jo, TXN2759PWilkinson Kevin · Alliance, NEN2759RFord William(Bill) A III · Abilene, TXN2759TLopas Jon D Trustee · Prescott, AZN2759WBar F Aviation LLC · Scottsbluff, NEN275AAAoa Kissimmee Inc · Kissimmee, FLN275AMAerodynamic LLC · Aurora, ORN275BBrunsvold Gene R · Selma, ORN275BMWestchester Flying Club Inc · Purchase, NYN275CBCalifornia Baptist University · Riverside, CAN275CCSellers Richard V · Byron, CAN275DFAspen Ring LLC · Bloomington, INN275DHHoward Henry · Justin, TXN275DMMaxfield Douglas R · Chico, CAN275DSMebane Alfred Holt IV Trustee · San Diego, CAN275FState Of Alaska Department Of Public Safety · Anchorage, AKN275FAFly Gateway Aviation Institute · New Castle, DEN275FLFox Leasing Group LLC · Hollywood, FLN275GTPs N275gt LLC · Green Bay, WIN275HPRich Aviation Services LLC · Fort Worth, TXN275JKKrol Jeffrey P · Somers, CTN275LESky Photoshop LLC · Winter Garden, FLN275MAFranzoy Steve · Salem, NMN275NDPlane Nonsense · Middletown, DEN275PEPhoenix East Aviation LLC · Daytona Beach, FLN275PTTruss Travis D · Stephenville, TXN275RBlue Card Aviation LLC · Conifer, CON275RCGianopoulous William · Lawrence, MAFirst renewal noticeN275RMRodgers Kenneth · Appleton, WIN275RVMccutchan Philip · Mount Vernon, IN
Back to AD 2007-04-19 R1