AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N2765XBa Aviation LLC · Anacortes, WAN2766FBrach Raymond S · Henderson, NVN2766JBedford Dennis · Auke Bay, AKN2766QThree Airmigos LLC · New Port Richey, FLN2766SJohnston Beryle Lee · Franklin, PAN2767GBrowns Valley Aviation LLC · Utica, KYN2767LGay David B · Citronelle, ALN2767UFisher James S · Texarkana, TXN2768GCarrion John H · Colusa, CAN2768JRussell Mark Alex · Fairbanks, AKN2768LJoseph Gary L · Ludlow, VTN2768SSibley Michael Neal · Kenai, AKN2768VRegistration Pending · Woodland Hills, CARegistration pendingN2768XMullett James L · Mccall, IDN2769FMatthews George W · Hillsboro, OHN2769GFraser Kevin J · Snohomish, WAN2769KMillennium Air Inc · Maurice, IAN2769LRedditt Brian W · Columbia Station, OHN2769QPrecision Truck Equipment Inc · Lansing, ILN2769UMckinney Edward L · Candler, NCFirst renewal noticeN2769ZPacheco Ricardo · Albuquerque, NMN276ACSmith Air Inc · Ukiah, CAN276AKSalo Mark W · Poulsbo, WAN276CKHuckabee Charles J · Seadrift, TXN276MABank Of Utah Trustee · Salt Lake City, UTN276NYFogarty Richard · Mandeville, LAN2770FEmmons Jack E · Elizabeth City, NCN2770SBirk Ronald G · Wellington, NVN2770UStandard Equipment Leasing And Sales LLC · Wilmington, DEN2771GWhitt Sana F III · East Quogue, NYN2771LP&N Corp · Marion, IAN2771UTobin Eric L · Cambridge, OHN2772JMagoffin David S · Fairbanks, AKN2772LBell William E Jr · Summerville, SCN2772XBratten Douglas D · North Pole, AKN2773FAdriatic Holdings LLC · Cheyenne, WYN2773JN2773j LLC · Titusville, FLN2773VBeale Air Force Base Aero Club · Beale Afb, CAN2773XLee Ty K · Anchorage, AKN2774JPerez Guillermo · Castaic, CAN2774QRdj Brothers Trucking Inc · Bigfork, MTN2774SPeterson Dennis · Cambridge, MNN2774XElk Creek Investments LLC · Helena, MTN2775EFaulkner Harry E Jr · Bethel, AKN2775FJock Carl A Trustee · Roscommon, MIN2775LKing Mons A · Paoli, PAN2775QRay Chris J · Ironside, ORN2775RMiller David · Tyler, TXN2775SRichardson Arthur · Herald, CAN2775ULuff John W · Odessa, MO
Back to AD 97-01-13