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.
N262ALDale County Sheriffs Office · Ozark, ALN262AMChapman Kevin Joseph · Williston, NDN262APKirk Donald D · Fairbanks, AKN262BGLarmore James N · Tucson, AZN262CACompass Aviation Inc · Shelby, NCN262CBCalifornia Baptist University · Riverside, CAN262CCHorton Charles M · Buckley, WAN262CLGiga Energy Inc · Buna, TXN262CPCivil Air Patrol · Maxwell Afb, ALN262DQIschi Phillip · Soldotna, AKN262E349 Ez LLC · Yakima, WAN262EAJeaps Aviation LLC · Edgewater, FLN262EEHorizon Flights Corp · Henderson, NVN262ERRoseville Aviation LLC · Roxboro, NCN262ESBreshears Michael · San Antonio, TXN262GCSlepica Michael · Oregon, WIN262GGN262ggllc LLC · Reno, NVN262GRDr I T Help LLC · Cheyenne, WYN262GSMinor Michael D · Grove City, PAN262MGordon Bruce · Marstons Mills, MAN262MJGillian Michael J · Batavia, ILN262MTBurns Mark R · Streetsboro, OHN262NDMoore Aviation Inc · Beaver Falls, PAN262NJJ2environmental LLC · Del Mar, CAN262PDGritter Richard J · Catlett, VAN262PEPorter Randall L · Athol, IDN262PMBig Bend Community College · Moses Lake, WAN262R262r LLC · Richland, WAN262RMDisrud Roger G · Olathe, KSN262RNPro Southern Aviation LLC · Franklin, NCN262SASundance Airport LLC · Yukon, OKN262WPage Jeffrey Vernon · Washington, PAN262WYMoore Enterprises Leasing Inc · Indianapolis, INN262XPrice Scott K · Sparks, MDN26300Boyer Steven L · Wooster, OHN26304Cobra Kai Inc · Wichita Falls, TXN2630GMarvil Sean · El Prado, NMN2630MMock Air LLC · Marion, INN2630QParrington Robert · Rifle, CON2630RBurdine Kenneth L · Newland, NCN2630UShaka Skies LLC · Kihei, HIN2630XBbjc Adventures LLC · Jackson, WIN26314Allen James R · Glasgow, KYN2631CAndrews John M · Titusville, FLN2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeN2631GMac Neil David M · Clarkston, WAN2631PFriebel Mark A · Shelby, OHN2631QManning Brian A · Malvern, IAN2631SAsplundh Eric P · Bryn Athyn, PAN2631WPlanes & Parts Inc · Weston, FL
Back to AD 2007-04-19 R1