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.
N1466UConcepcion Leonardo · Downey, CAN1466VGak Flight LLC · Scandia, MNN1467FJetceo LLC · Kalispell, MTN1467TThree2tango LLC · Mount Pleasant, SCN1467XWilson David K · Mckinney, TXN14680Hendricks Aric W · Floydada, TXN14687Dalessio Enterprises Inc · Smithville, TNN1468DAhrens David R · Guthrie Center, IAN1468MArctic Barnabas Ministries · Kenai, AKN1468THindle John Charles IV · Whitehouse Station, NJN1468VMonmouth Flying Club · Monmouth, ILN14690Davis Scott · Morse, TXN14691Weakley Robert Kayce · Pleasant View, TNN14695Johnson Charles E · Vernon, TXN1469FSkywagon 185 LLC · Ocala, FLN1469SS & J Farms · Floydada, TXN1469TThree Wing Flight School LLC · Stratford, CTN146BPNoughton Larry W · Fort Myers, FLN146CPlanes & Parts Inc · Weston, FLN146DSale Reported · San Diego, CASale reported, pending cancellationN146DB4405 LLC · Jenks, OKN146DCAztec Worldwide Airlines Inc · Wilmington, DEN146FCUsda Forest Service Fepp · Malvern, ARN146JMarc Inc · Bolton, MSN146JWDodge Inc · Wilmington, DEN146LWBelvedere Inc · Marion, IAN146MBMlc Flying Club LLC · Saint Peters, MON146PWilliams Mike C · Sonora, TXN146PTCoco Aircraft Inc · Merritt Island, FLN146RAerospatiale LLC · Selah, WAN146SCFantasy Aire Inc · Wilmington, DEN146SWFairway Systems LLC · New Port Richey, FLN146TAShamash Micah I · Larkspur, CON146YBayer Peter D · Naperville, ILN146YSHorn George A · Spicewood, TXN146ZUtah State University · Logan, UTN14702Cartel Oil Records LLC · Kansas City, MON14705Bernath Robert J · Saint Johns, FLN14706Carter Delton W · Sumner, TXN14709Godfrey Lawrence J · Leucadia, CAN1470BBerger Leo · Nampa, IDN1470GBaker Dennis J · Shipman, ILN1470HCherokee Air Inc · Lexington, SCN1470QHillyer Joe F · Soldotna, AKN1470UScientific Aerial Imaging Inc · Saint Helena, CAN1470VGiron Lawrence N · Anchorage, AKN14714Poco Loco LLC · Mesa, AZN14718Slys Aircraft Service · Platte, SDN1471DSchwarzkopf Michael A · St Peters, MON1471EKdrd Holdings LLC · Texas City, TX
Back to AD 98-21-21 R1