AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.
N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJN8808DDwight Thomas W · Castalia, OHN8808YAukes Brian E · Huxley, IAN8809PPa24 LLC · Painesville, OHN880FTFlorida Institute Of Technology · Melbourne, FLN8810CGroenwegen Bruce C · Snohomish, WAN8810DNorman Timothy J · Tofte, MNN8811YHutchinson Douglas E · Cle Elum, WAN8812DSowders Darwin G · Robinson, TXN8812PRegistered aircraftN8812YSpain Air LLC · Dadeville, ALN8813PWolcott Kent E · Colorado Springs, CON8814YTwin C 14y LLC · Cape Coral, FLN8815YBauer Andrew J · Concord, NCN8816CNye Brian M · Independence, ORN8816LWindy City Soaring Association · Hinckley, ILN8817PTei Corp · Kalispell, MTN8817YWiehl Thomas K III · Earlysville, VAN8818CHalligan Austin C · Sidney, NEN8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8819PN8819p LLC · Boca Raton, FLN881FTFlorida Institute Of Technology · Melbourne, FLN8820CPfaff Kirk J · Jamul, CAN8820DMayo Jesse J · Fairbanks, AKN8821LSouthern California Soaring Academy Inc · Valencia, CAN8822DWhite Glen A · Timber, ORN8822PCornwell Charles E · Tucson, AZN8823YFerrara John M · Newtown, PAN8824PAzimi Matthew H · Navarre, FLN8826DSongster Kevin M · Friend, NEN8826PIngalls Equipment LLC · Redlands, CAN8829CJohnson Steven D · Pardeeville, WIN8829DSchwenninger Ronald L · Allison Park, PAN8829LPotter Everett A · Lansford, NDN8829PInternational Air Services Inc Trustee · Carson City, NVN882ATDot Aviation LLC · Wilmington, DEN882FTFlorida Institute Of Technology · Melbourne, FLN8830LKolb Austin · Phoenixville, PAN8830PCanon Daniel H · Fruit Cove, FLN8831CWright Michael · Hurricane, UTN8832CSale Reported · Coulterville, ILSale reported, canceledN8832LMid Continent Aircraft Corp · Hayti, MON8832PRoundtree Benjamin · Cass City, MIN8833CBall Gerald C · Wasilla, AKN8833PRegistered aircraftN8833YGagan Samrat LLC · Charlotte, NCN8834CSindelar David C · Franklin, KYN8835DBrocke Rodney A · Bay City, MIN8835PFeller James P · Granite Bay, CAN8836YLodge Aviation LLC · Lewes, DE
Back to AD 85-02-05 R1