AD 84-10-01 R1
Registered aircraft · 20,485
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.
N180RAWold John O III · Laurel, MTN180RDSchmid David J · Anchorage, AKN180RFSoloy Matthew C · Palmer, AKN180RHHorning Richard H · Galion, OHN180RJKindred David M · Soldotna, AKN180RLLeibenguth R E · Palmerton, PAN180RNCrider Michael A · Willow, AKN180RPPulley Richard A · Chugiak, AKN180RTTiernan Barton M · Anchorage, AKN180RUBarrett William G Jr · Williams Bay, WIN180RWHennis Jess L · Cottonwood, IDN180RXKaram John G · Reno, NVN180RYBaker Dean · Cave Creek, AZN180SBensinger William I · Seattle, WAN180SAGregory Larry C · Farmington, MON180SBAzul Aviation LLC · Post Falls, IDN180SFFranklin James T III · Vero Beach, FLN180SGM&S Equipment Leasing LLC · Dalhart, TXN180SHHaselberger James J · Fairbanks, AKN180SJRudy Styx LLC · Williams, MNN180SKSt George James · Anchorage, AKN180SMSullivan Brandon M · Cloudcroft, NMN180SNNielson Donald L · Independence, ORN180SRMcdonald John C · Houston, AKN180SWHurt Joseph S · Odessa, TXN180SZHomrok John C · South Kent, CTN180TBPort Townsend Aero Museum · Port Townsend, WAN180TCHallsten Stephen B · Fairbanks, AKN180TFMontanelli Peter A · Anchorage, AKN180TKSeymour Laurie A · Marshfield, MAN180TLDoebler H Andrew · Mebane, NCN180TMMccorkle Farms Inc · Glenn, CAN180TNJensen Arden T Jr · Auburn, WAN180TPLayson Aviation LLC · Spring Lake, MIN180TRMccann Michael P · Ocala, FLN180TW180 Tw LLC · Rexburg, IDN180UBS T O L LLC · Eagle, IDN180UFBrown Bryan L · Greenwood, ARN180VTrigger Gap Aviation LLC · Kalispell, MTN180VTJlng Air LLC · Scottsdale, AZN180VWTwo LLC · South Paris, MEN180WStein Anthony J · Locust Grove, GAN180WAHelland Gregory A · Wayzata, MNN180WBSchroder Robert D · Buckeye, AZN180WDRegistered aircraftN180WFPowell William A · Falkville, ALN180WGGray Howard W Jr · Grand Prairie, TXN180WHKaltenbach Kevin W · Stanwood, WAN180WJPlane Fun Inc Tr Trustee · Snellville, GAN180WLMerker Christopher R · Lewistown, MT
Back to AD 84-10-01 R1