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.
N8637PDavenport Erik Jon · Cumming, GAN8638LTulsa Skyhawks Inc · Tulsa, OKN8638PBartell John B · Elgin, ILN8639CGeorge James A · Jackson, GAN8639PJohnson James E · Calhoun, LAN863ATCxk1 LLC · Wilmington, DEN8640CGiddens Robert F · Duncan, OKN8641PN8641p LLC · Gainesville, GAN8642LTexas Soaring Assn · Midlothian, TXN8643DBurns Roni R · Bolivar, MON8643PCheatwood Owen Larry · Granbury, TXN8644PFord Bernard C · Sidney, NYN8646CFilice Gennero J · Rohnert Park, CAN8646DAdams James F · Flagstaff, AZN8647CBrown Roger K · Port Saint Lucie, FLN86483Eaa Aviation Foundation Inc · Oshkosh, WIN8648CHouse Justin W · Uriah, ALN8648PSelinger Richard · Seal Beach, CAN8648YChuss Edward · Metamora, MIN8649DGho Michael M · Fairbanks, AKN8649PMelodia Sean M · Cranberry Township, PAN864ATCxk1 LLC · Wilmington, DEN8651PGottschall Kenneth Lee III · Santa Paula, CAN8654DTreml Kent E · Luxemburg, WIN8654PRoman Louis · Bridgeport, CTN8655PBrewster Michael L · Nipomo, CAN8656LAdirondack Soaring Association Inc · Ballston Spa, NYN8656PMcdonald Gregory S · Mena, ARN8657DParks John T · Ripon, WIN8657PSchoolcraft Carl L · West Harrison, INN8658LMid Atlantic Soaring Association Inc · Frederick, MDN8658PPannell Butch W · Spring Branch, TXN8659PFiebig Howard James · Sebewaing, MIN8660DManuella Timothy J · Sandusky, OHN8661DSheets Wayne H · Hagaman, NYN8661PEast Texas Turbines Inc · Tyler, TXN8662PPearson Trevor D · San Ysidro, CAN8662YCappiello Robert M · Canyon Country, CAN8663DLawrence Alexander · Miamisburg, OHN8663PNewman Nate · Lincoln, VTN8664DWyant David Mark · Dallas, TXN8665POhayon Eli · San Diego, CAN8665YRebelair LLC · Stevens Point, WIN8666YZimmermann Aviation LLC · Lake Worth Beach, FLN8667PHeffner Christopher Jay · Williamsport, PAN8667YCurran Michael · Gallatin, TNN8668PGrizzle Jason M · Roscoe, TXN8668YBennett Karl M · Wellington, FLN8669YThermo-Tech Air LLC · Keyser, WVN866ATCxk1 LLC · Wilmington, DE
Back to AD 85-02-05 R1