AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N1QPN667sr LLC · Richmond, KYN1TBR S Rowe Enterprises Inc Sp · Wilmington, DEN1YDBerg Bradley · Tulare, CAN1YTOne Yankee Tango LLC · Jenks, OKN1ZTHolman Daniel P · Eagle River, AKN2001RAllen Aeronautics LLC · Mocksville, NCN2002FTextron Aviation Inc · Wichita, KSN2002RWentzel Jason A · Dupont, WAN2003GHuntley Richard W · Bellingham, WAN2003RPrestige Worldwide Aviation LLC · Downers Grove, ILN2004RMorasch Robert G · Walla Walla, WAN2004XCovetous Inc · Fallbrook, CAN2005GGreat Basin Aviation LLC · Eagle River, AKN2005XTurnmire Jeffry B · Knoxville, TNN2006GYates Rodney R · Hubbard, ORN2006PKnox Timothy A · Tulsa, OKN2006RBarclay Mechanical Services Of Utah Inc · Manti, UTN2007RDoc'S Flying Club LLC · Macon, GAN2007TWinger Raymond E · Johnson, KSN2007VCompass Rose Aviation LLC · Derby, KSN2008GChaump Michael · Reno, NVN20099Wehnam Kenneth J · Shingle Springs, CAN200HPOklahoma Department Of Public Safety · Norman, OKN200LDFenske Jeffrey D · Gold Hill, ORN200NMOrr Leroy A · Tonasket, WAN200QRPdq Flight Inc · Garden City, NYN200RCRc Aviation LLC · Omaha, NEN200TLHusnik Brad M · Forest Lake, MNN200UAUrrea Hugo Edmundo Rincon · Houston, TXN200VVN200vv LLC · Pontiac, MIN200WRVaughan Jason B · Sublette, KSN2010GFox Stephen A · Wasilla, AKN2010XHutchinson Darrold K Trustee · Hingham, MTN2011SHeath Stephen · Alpine, TNN2011XSalem Ricky L · Burnet, TXN20126Papa Whiskey Enterprises LLC · Merrimack, NHN2012GMchugh Michael J Trustee · Hailey, IDN2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMN2012S9791m LLC · Tacoma, WAN2012YLake Robert P · Fruita, CON2013RZinsmeyer Charles D · Llano, TXN2013XEec Group LLC · Kalispell, MTN2014Blue Skies Trading Company LLC · Toledo, OHN2014RDaedalus Wings Inc · Malvern, OHN2014SGaige Gerald · Gassville, ARN2014XTashjian Kirk G · Stanwood, WAN2015RBennett Peter D · Birmingham, ALN2015XAircraft Trade Group LLC · Scandia, MNN2016RCoburn William L · Snohomish, WAN2016XSmith James A · Lyle, WA
Back to AD 84-10-01 R1