Skip to content

Registered aircraft · 25,370

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

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:80-25-07-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:80-25-07-R1') ORDER BY n_number

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N4330QSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1971 · S/N 17260230 N4331QLewis Brandon · Columbiaville, MIBuilt 1971 · S/N 17260231 N4331RConsolidated Aviation Services LLC · Seymour, TNBuilt 1974 · S/N 17263084 N4332COdom Douglas · Jay, FLBuilt 1978 · S/N 18803135T N4332RHolland Peter B · Uniontown, WABuilt 1974 · S/N 17263085 N4333KWeisbeck Kenneth J · Scottsdale, AZS/N 115-2 N4333RReigle Aviation · Palmyra, PABuilt 1974 · S/N 17263086 N4334LOcuto Vincent Louis II · Homestead, FLS/N 17269555 N4334QDickey Alan J · Fort Wayne, INBuilt 1971 · S/N 17260234 N4334RAir Dakota Flite Inc · Hettinger, NDBuilt 1974 · S/N 17263087 N4335HRiisnaes Alf Kare E · Rapid City, SDBuilt 1978 · S/N 24-0709 N4336HKozak Frank E · Santa Maria, CABuilt 1978 · S/N 24-0710 N4336MSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802472T N4337QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260237 N4338QRegistration Pending · Salisbury, NCRegistration pendingBuilt 1971 · S/N 17260238 N4338RThompson Group Inc · Stockton, CABuilt 1974 · S/N 17263091 N4339HKaufman Timothy H Trustee · Saint Charles, MIBuilt 1978 · S/N 24-0711 N4339QC & K Aero LLC · La Valle, WIBuilt 1971 · S/N 17260239 N4339RBurke Brian · Westlake, OHBuilt 1974 · S/N 17263092 N433BPLeverock Richard C · Port Saint Lucie, FLBuilt 1981 · S/N P21000730 N433PTPilot Training Center LLC · Miami, FLBuilt 1974 · S/N 17263088 N433RMRocky Mountain College · Billings, MTBuilt 1974 · S/N 17262914 N433TJKennedy John A · Marietta, GABuilt 1992 · S/N 661-92 N4341HGunstream Jesse B III · League City, TXBuilt 1978 · S/N 24-0712 N4341ROleary Paul V · Gold Creek, MTBuilt 1974 · S/N 17263094 N4342EMoon Jonathan Edward · Butler, PABuilt 1978 · S/N 38-78A0564 N4343QK M Air Enterprises Inc · Corona, CABuilt 1971 · S/N 17260243 N4343REndless Sky Aviation Inc · Syracuse, NYBuilt 1974 · S/N 17263096 N4345QNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1971 · S/N 17260245 N4346HStrickland Mark J · Arlington, TXBuilt 1978 · S/N 24-0713 N4346QCorrado Christian Blake · South Point, OHBuilt 1971 · S/N 17260246 N4346RFlyhnz LLC · Oxford, NCBuilt 1974 · S/N 17263097 N4347ECarver Lloyd · Snellville, GABuilt 1978 · S/N 38-78A0570 N4347RAvair LLC · Westville, INS/N 17265205 N4349RVaughan James · Meansville, GABuilt 1974 · S/N 17263100 N434DTTiffany David J · Lyme, CTBuilt 2008 · S/N 509-2008 N434RBBrown Brian M · Downey, CABuilt 1976 · S/N 0740 N4350EUrgiles Carbaca Andres A · Lantana, FLBuilt 1978 · S/N 38-78A0571 N4350HKieser Investments LLC · Bloomington, ILBuilt 1978 · S/N 24-0716 N4350RB2 West Corp · Winona, MNBuilt 1974 · S/N 17263101 N4351QJohnson James Benjamin · Rosharon, TXBuilt 1971 · S/N 17260251 N4351RVertol Systems Co Inc · Destin, FLBuilt 1974 · S/N 17263102 N4352RQuad City Area Flying Eagles · Milan, ILBuilt 1974 · S/N 17263103 N4353QHaley Paul M · Hillsboro, NHBuilt 1971 · S/N 17260253 N4355QSalcido Antonio Sr · Idaho Falls, IDS/N 17260255 N4356EGarcia Alfonso · Lovington, NMFirst renewal noticeBuilt 1978 · S/N 38-78A0573 N4358RBig M Flying Club Inc · Aberdeen, WABuilt 1974 · S/N 17263109 N4359QDollar Christopher S · Spring Hill, TNBuilt 1971 · S/N 17260259 N4359RAircraft Resources Inc · Crescent City, FLBuilt 1978 · S/N R18200593 N435DBHigh Velocity Design Inc · Ferndale, MIBuilt 1966 · S/N 1250

Back to AD 80-25-07 R1