AD 98-21-21 R1
Registered aircraft · 85,620
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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.
N180PCRisen LLC · Urbandale, IAN180PGRance Cory D · Moody, TXN180PHCornell David A · Palmer, AKN180PJBlackhurst John · Embarrass, MNN180PKChagnot Catherine J · Athens, OHN180PPLaughbon Ladd · Carson City, NVN180PRRuttley Enterprises Inc · Marrero, LAN180PTProcaccini Donald P Jr · Spring Hill, FLN180PWHerrold Alvin J III · Seward, NEN180PXFloerke Keith Joseph Jr · Taft, TXN180RAWold 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, AZ
Back to AD 98-21-21 R1