AD 84-10-01 R1
Registered aircraft · 20,481
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.
N59210Safe Pilots Group LLC · Nyack, NYN5921EPeterson Dennis L · Daleville, ALN5922BLitton John C · Quartz Hill, CAN5922JMerlin Iron Works LLC · Westwood, KSN59237Boland Matthew S · Anchorage, AKN5923BWilson Phillip K · Waukesha, WIN59240Banegas Jose Carlos Zankiz · Flint, TXN5924BZarinnia Anthony · Chelsea, MIN59258Energy Roofing Technology Se LLC · Lake City, FLN5926JVintage Aviation LLC · Billings, MTN5927BEmerson Christopher D · Mount Pleasant, ARN59286Staley Ronald L · Lebanon, ORN5928BSteinhausen Darrell · Torrington, WYN5928FKerr Daniel · Bakersfield, CAN59292Cloud Busters LLC · Goodrich, MIN59294Cornucopia Investment Group LLC · South Jordan, UTN59299Aircraft Guaranty Corp Trustee · Oklahoma City, OKN5929BRegistered aircraftN592JSStraut James M · Upper Saddle River, NJN592KBCopper River Airmotive LLC · Copper Center, AKN5930FCable Strong Aircraft Holdings LLC · Tyler, TXN5932BAbsolute Altitude LLC · Buena Vista, CON5932JOwen Stephen M · Wiggins, MSN5933BManier Byron K · Houston, MON5934BLlk Aviaiton LLC · Hanksville, UTN5935JSwinden Jonathan · Danville, PAN5936BTorrison Scott D · Chugiak, AKN5937FDodson International Parts Inc · Rantoul, KSN5938BDocjosh Ltd LLC · Essex, NYN5939EWhite Sound International Ltd · New Smyrna Beach, FLN593CPCivil Air Patrol · Montgomery, ALN5943GFlight Express LLC · Henry, TNN5946JMillett Paul B · Claremore, OKN5947FGulf Coast Aviation LLC · Terra Ceia, FLN5948F5c1 Ltd · Boerne, TXN5949FRead Travis E · Lumberton, TXN594CF4cf Partnership · Fall River Mills, CAN594CPCivil Air Patrol · Maxwell Afb, ALN5950GSmylie Michael Dean · Douglas, WYN5952FRedmon David M · Biloxi, MSN5953BElevate Air Inc · Titusville, FLN5953FKnickerbocker Thomas C · Houston, TXN5955BHess Garrett · Fullerton, CAN5956XCox David F · Tucson, AZN5957BMiss Mayson LLC · Midland, TXN5961BC&B Aerial Transport Inc · Wilmington, DEN5963BJones Damon · Lafayette, ORN5964BBailey Steven W · Puyallup, WAN5965BMathison John M · Vancouver, WAN5966BLemaster Roxanne · Brookville, OH
Back to AD 84-10-01 R1