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.
N3526NDace Joshua R · Rochester Hills, MIN3526UThomason Tommy Eugene Trustee · Scottsdale, AZN3526WN3526w Holding LLC · Harlem, GAN3526XSchiebel Philip A · Walla Walla, WAN3526ZSwett John P · Zebulon, NCN3527Link James L · Raleigh, NCN35273Weltmer Aaron Reece · Rocklin, CAN35278Sparks Tommy R · Palestine, ILN3527FTuorila Tony C · Anderson, SCN3527HFlight Meo LLC · Daytona Beach, FLN3527NMooney 3527 LLC · North Las Vegas, NVN3527YHrobak Robert F · Winter Garden, FLN35281Freebird Wings LLC · Creswell, ORN35284Flying Redbirds LLC · Wentzville, MON35287White James E · Eminence, KYN35288Van Wagner Aerial Media LLC · Hollywood, FLN3528DBank Of Utah Trustee · Salt Lake City, UTN3528FFair Paul R · Vacaville, CAN3528HBlack Kevin John · Edgewater, FLN3528PSalerno Joseph C Jr · Gettysburg, PAN352964 Point Transportation LLC · Excelsior Springs, MON3529KEagle Sky Patrol Inc · Deadwood, SDN3529XPurpose Flight Inc · Wilmington, DEN352ACFlight Leasing Corp · Wilmington, DEN352AKKwartler Anatol · Maynard, MAN352AMWarren John L · Homer, AKN352BGBowling Green Flight Center LLC · Bowling Green, OHN352CPCivil Air Patrol · Maxwell Afb, ALN352GAura LLC · Zeeland, MIN352LBurdick Rich · Montrose, CON352MAKilo Tango Aviation LLC · Watford City, NDN352MKNorth Star Aviation · Mankato, MNN352RCN352rc Inc Trustee · Wilmington, DEN352RHHackler Russell W Jr · Livermore, CAN352SPChristiansen Aviation LLC · Wilmington, DEN352TImpact Aviation LLC · Ballwin, MON352TBJdc Aviation LLC · Gainesville, FLN352TSBoss Contract Services LLC · Terry, MTN352VAVictory Aviation Club Inc · Hamilton, OHN352ZAlpha Tango Aircraft LLC · Wilmington, DEN353Giddings Thomas C · Fort Myers, FLN35302William Benjamin LLC · Orono, MNN35308Kress Gregory A · Sharpsburg, GAN3530FHeames Scott D · Simi Valley, CAN3530KCook Richard A · Deshler, OHN3530MComer Robert E · Greensburg, INN3530PYaroslavski Limited Partnership · Norman, OKN3530TAllison Thomas D · Council Hill, OKN3530UKalmbach Justin J · Polson, MTN3530XLorenz George W · Downers Grove, IL
Back to AD 2007-04-19 R1