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.
N3550UYoung Mary J D · Waynesville, OHN3550YForman Barnes LLC · Nampa, IDN3550ZMcmillian Dean R · Wasilla, AKN35514Flying Services Inc · Wilmington, DEN35517Mulder Kathleen M · Palmyra, PAN35519Baranowski John · Pleasant Grove, UTN3551FBursley Richard R · Phoenix, AZN3551QHeatley Thomas L Jr · Gleason, TNN3551UFallini Anna M · Tonopah, NVN3551YWethered Dvm LLC · Boise, IDN3551ZAlpine Cable & Construction Inc · Grand Junction, CON35528Curtin John J · Palos Heights, ILN3552DBarwick H Brooks III · Clinton, NCN3552EAngel Aviation Inc · Peoria, AZN3552FAirplanes Over Niagara LLC · Lewiston, NYN3552JSale Reported · Middletown, CASale reportedN3552L4wblue LLC · Waccabuc, NYN3552MArcher Enterprises Inc · Sac City, IAN3552QRegistered aircraftN3552WTwo Sixty Aviation LLC · Wilmington, NCN3552ZMccartney David J · Lake Stevens, WAN35530Trs Holdings LLC · Kalispell, MTN3553JLade Burton G · Bemidji, MNN3553MIxi LLC · West Bloomfield, MIN3553WVarn Samuel G · Thomasville, GAN3553YMiller Jaime W · Deer Park, NYN35542Kyzer Kevin G · Fort Mill, SCN35543Parrish Aviation Flight Academy LLC · Southlake, TXN35544Sunquest Aircraft LLC · Wappingers Falls, NYN35546Independent Aviation Services LLC · Sachse, TXN3554EZin Services LLC · Dove, DEN3554LHarding Nelson · Lebanon, ORN3554MWacker Peter K · Marietta, GAN3554NPatterson Ted · Skiatook, OKN3554WPerkins Chas L · Warsaw, MON3554ZJacobi Gregory A · Alex, OKN35553Redstone Arsenal Flying Activity · Redstone Arsenal, ALFirst renewal noticeN35554J&T Aviation LLC · Colleyville, TXN3555FStern Andrew · New York, NYN3555NLarimore Jacob William · Ypsilanti, MIN3555WF&F Aviation LLC · Worthington, OHN35560Bolling Daniel M · Oxford, MEN35564Port Townsend Aero Museum · Port Townsend, WAN35565Cochran Brent D · Sandy Valley, NVN35567Searfus Kirsten · Durango, CON35569Long Daniel W · Carrollton, GAN3556PPlanes & Things Inc · Collinsville, OKN3556VWestbank Fishing LLC · Kiln, MSN3556YLodestar Aviation LLC · Mooresville, NCN35575Sky Flight Robotics Inc · Freeland, MI
Back to AD 2007-04-19 R1