AD 98-21-21 R1
Registered aircraft · 85,616
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.
N1149PWilliams Joseph A · Jacksonville, FLN1149UFerraro Alfred A Jr · Milford, CTN1149XGossman Mitchell V · Saint Cloud, MNN114AGRlc Aviation LLC · Ansted, WVN114AMLon Air LLC · Longwood, FLN114BBServtek LLC · Waterloo, WIN114CDNorwest Ventures LLC · Santa Cruz, CAN114CFAw Chartering LLC · Franklin, TNN114ELNaperville Flying Club · Woodridge, ILN114FMoore Joe L · Cortez, CON114FAJprg Aviation Inc · Orlando, FLN114JDVintage Motors Inc · Beattyville, KYN114JRN114jr LLC · Canyon Lake, CAN114NXin Han Aviation LLC · Atwater, CAN114NCFair Air Inc · Bloomfield Hills, MIN114PCKjr3 Aviation LLC · Weatherford, TXN114PGRegional Medical · Stephentown, NYN114PJRowe John J · Kansas City, MON114PLMaxwell Jeffreyi · Drayden, MDN114PRC W 3 LLC · San Juan, PRN114RYoung John R · Rockland, MAN114RSLuggelle Michael · Hull, MAN114SIrby Darrell L · Keller, TXN114SACustom Air International LLC · Homestead, FLN114TPGrj LLC · Lexington, SCN114WPUniversal Aviators Academy Inc · El Monte, CAN114WREstes Aviation LLC · Vicksburg, MSN114XTaft Plumbing Co Inc · Taft, CAN1150GGinocchio John A · Minden, NVN1150UHaskins Kerry H · Tampa, FLN1150XVenture North Aviation LLC · Cloquet, MNN1151HMooney N1151h LLC · Virginia Beach, VAN1151NMuller Keith M · Palm City, FLN1151UCoconut Telegraph LLC · Missoula, MTN1151VJamison Angela Michelle · Riverside, CAN1151XSummers Jayson V · Poway, CAN11520Bernstein Harry A Md · Las Cruces, NMN1152GN1152g LLC · Oklahoma City, OKN1152KVan Hook James W · Sylvania, OHN1152LMcdonald Glenn · Uvalde, TXN1152MRst Aviation LLC · Vero Beach, FLN1152NDowd Tedd J · Goodyear, AZN1152QHilterbrand Wayne D Jr · Keizer, ORN1153KFraley Jason · Gulfport, FLN1153QHall Robert L · Edgewood, TXN1153WMyhre Keith · Billings, MTN11541Upskirt Aviation LLC · Fredericktown, MON1154USinger Daniel · Marco Island, FLN1154XKelley Jay D · Lake Havasu City, AZN11555Euroaviation Inc Trustee · Kematen
Back to AD 98-21-21 R1