OpenAirDocs.org
AD 2013-03-10

Registered aircraft · 4,369

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:2013-03-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-03-10')
  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.

N1000GSumofiber LLC · Bountiful, UTBuilt 2025 · S/N 2451N1004YNakamura Judith · Placitas, NMBuilt 2006 · S/N 6384N100UMKing Michael G · Sandia Park, NMBuilt 2000 · S/N 6272N10113Skywalker Balloon Co LLC · Tallahassee, FLBuilt 2021 · S/N 1790N101CFClark Floyd Counties Convention & Tourism Bureau · Jeffersonville, INBuilt 2018 · S/N 6852N101ZLAllen Scott · Overland Park, KSBuilt 2009 · S/N 6571N1022RRegistered aircraftS/N 6446N1024BBaldwin Roger · Bosque Farms, NMBuilt 2004 · S/N 6371N102BMBradley Boroughs Inc · Louisville, KYBuilt 2003 · S/N 77/231N102LBCatskill Mountain Balloon Inc · Oneonta, NYBuilt 2015 · S/N 5575N103LBBalloon Promotions Ltd · Louisville, KYBuilt 2000 · S/N 5157N10418Crook Rick D · North East, MDS/N 6392N1042QElevatednm LLC · Los Ranchos, NMBuilt 2005 · S/N 6399N10436Go Ballooning LLC · Anchorage, AKBuilt 2005 · S/N 6395N1046GMonahan Todd J · Queensbury, NYBuilt 2004 · S/N 6376N1049FBissonette Harle E · Brookings, ORBuilt 1979 · S/N 182N1049YAirtime Equipment LLC · Mesa, AZBuilt 2005 · S/N 6429N104DLMartin Harold J · Hobbs, NMS/N 11036N104LBDougherty Don A · Colorado Springs, COBuilt 1998 · S/N 5079N104TCAskren Richard S · Middletown, OHBuilt 1996 · S/N 3971N1053PKerber Rick · Wayland, MIBuilt 2004 · S/N 6378N10589Belgarde Ashley T · Fitchburg, WIS/N 048N1059BDimmitt William C · Los Lunas, NMS/N 054N1059SMoughan Gavin P · Albuquerque, NMBuilt 1979 · S/N 046N1059YZielinski Gary R · Gainesville, GABuilt 1982 · S/N 092N1059ZGauthier Daniel R · Waterford, MIBuilt 1981 · S/N 073N105BLPhilkill Steven R · Milford, NJBuilt 2009 · S/N 6553N105BMVan Sant Lori R · Albuquerque, NMBuilt 2008 · S/N 6538N105CNHot Air Balloonatics LLC · Henrico, VABuilt 2015 · S/N 6771N105CPPengelly Curt A · Boise, IDS/N 1831N105EHRadowski Johnathan P · Phoenix, AZS/N 068N105FFAdie Martin · Edgewood, NMS/N 6582N105GHMagniflight LLC · Arlington, TXBuilt 2018 · S/N 5675N105HMGliatti Michael E · Oregonia, OHBuilt 2020 · S/N 5710N105KBBarrett Dennis F · Temecula, CABuilt 2015 · S/N 1181N105MLBraden R Morgan · Lake Havasu City, AZBuilt 2017 · S/N 1370N105PFFan-C Inc · Loveland, COBuilt 2004 · S/N 5282N105PRRadloff David · Lake George, NYBuilt 2013 · S/N 6678N105RBTriple T Aviation LLC · Los Lunas, NMBuilt 2020 · S/N 6922N105RRNapa Valley Aloft Inc · Yountville, CABuilt 2003 · S/N 6353N105SGGibboneys Aerostation LLC · Grove City, OHBuilt 1998 · S/N S60A-3250N105UMGoss Richard L · Leander, TXBuilt 2004 · S/N 105/118N105VTApogee Associates LLC · Portage, MIBuilt 2006 · S/N 355N105YVCalifornia Balloon Repair Inc · Dixon, CABuilt 2022 · S/N 6955N105ZTBigfoot Aviation LLC · Salt Lake City, UTS/N 6566N105ZZWhitehead Jonathan S · Steamboat Springs, COBuilt 2013 · S/N 1011N1061AAmlong Jeanine M · Rio Rancho, NMS/N 045N1061GWilson Daniel E · Tucson, AZBuilt 1979 · S/N 058N1061HBristol David W · Sautee Nacoochee, GAS/N 044N1061SDepew Michael P · Nashua, NHS/N 053
Back to AD 2013-03-10