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.
N1762HFlorida Sky Aviation LLC · Clearwater, FLN1762WWillis Frederick A · Scottsdale, AZN17632Hunt Elizabeth H · Clifton, TXN17636Rocha Heriberto · Houston, TXN17639Peterson Eric S · San Jose, CAN1763JTeeter Adam B · Cambridge, MNN1763MHaines Robert F · Carlsbad, CAN1763TCroft Kevin Wallace · Durant, OKN1763W63 Whiskey LLC · Seattle, WAN1763XRobins Nest Aviation LLC · Harrison, OHN1764CRyan Michael · Gillette, WYN1764TTrabold Peter · North Adams, MAN1764VGross John F · Winthrop, MEN1764XLeschber Larry · Hutto, TXN17650Pynes Anthony P · Round Rock, TXN17653Coggin Randall · Longview, TXN17656Liddell Patrick A · Columbia Falls, MTN1765FKohler Daniel J · Mapleton, ORN1765GGivens Thomas A · Southern Pines, NCN1765HMcumber James W · Elkin, NCN1765JMay Olivia G · Santa Rosa, CAN1765MFlying Cow LLC · Syracuse, NYN1765RPlane Pro Aviation LLC · Shelby, NCN1765TFlyhome Aviation LLC · Miami, OKN17660Simpson Chad · Harrison, ARN17668Broadway Travis A · Alexandria, LAN17669Srg Enterprises LLC · Montgomery, ALN1766GCallaway Ike Wingate Jr · Tampa, FLN1766HOrlandi Properties LLC · Blairstown, NJN1766MN1776m LLC · Panama City, FLN1766VCode4 Ventures Inc DBA · Waynesboro, VAN1767GFranceus Maurice Michael · Temperance, MIN1767JHutcheson Jeffrey K · Council Bluffs, IAN1767MAnderson Thomas C Trustee · Sun City West, AZN1767RHamel David A · Klamath Falls, ORN1767WN1767w LLC · Dover, DEN1768ERoyal Air Freight Inc · Waterford, MIN1768GRl Hoffman Aviation Services Inc · Sanders, KYN1768JTrepanier Richard Alain · Benson, AZN1768TButler Thomas E · Arcadia, FLN1768VBrown Craig D · Fort Wayne, INN17692Starnes Robert D · Suwanee, GAN17698Spindel Stuart H · Hawesville, KYN1769RCt Aviation LLC · Waverly, NEN1769TCaudle Steve W · Glencoe, ALN176AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN176BRegier Tom · Dinuba, CAN176CMBoard Of Trustees Of Western Michigan University · Battle Creek, MIN176DRKelly Daniel · Alpharetta, GAN176DXPiper Aircraft Inc · Vero Beach, FL
Back to AD 98-21-21 R1