Skip to content

Registered aircraft · 40,395

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

N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518 N3363MGlatt David · Bonita Springs, FLBuilt 1947 · S/N 12-2219 N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320 N33640Red Rooster Rentals LLC · Alto, GABuilt 1975 · S/N 28-7515349 N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161 N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219 N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519 N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664 N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220 N33659North Central Flight Center LLC · Warwick, RIBuilt 1975 · S/N 28-7515351 N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170 N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919 N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163 N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165 N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166 N33672Nulton Enterprises LLC · Johnstown, PABuilt 1975 · S/N 28-7515298 N33673Borregard Robert Stephen · San Jose, CAS/N 28-7515306 N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222 N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224 N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167 N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283 N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227 N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170 N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520 N3369TBauer Charles · Graceville, MNS/N 17700669 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336BWAllen Scott L · Ogallala, NEBuilt 2001 · S/N 4352 N336DBGustafson Gary E · Motley, MNBuilt 2005 · S/N 90805 N336NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 120M N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140 N336RABrown Donald B · Virginia Beach, VABuilt 1978 · S/N 3098 N336RVVose Kristin M · Bloomington, ILBuilt 2001 · S/N 60199 N336SBPieternelle J Coffy · Beaumont, TXBuilt 1973 · S/N 28-7305489 N33715Wdc Enterprises LLC · Beaumont, TXBuilt 1975 · S/N 28-7525231 N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521 N3371RRs Helicopters Inc · Winter Haven, FLS/N 3371 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N33727Cohran Chuck Earl · Bowdon, GABuilt 1975 · S/N 28-7515358 N33728Howard Andrew · Chillicothe, OHBuilt 1975 · S/N 28-7505173 N3372ZPhilbrick Stephen C · Oquossoc, MEFirst renewal noticeBuilt 1960 · S/N 18-7245 N33745Hunt Joel P · Berlin, WIBuilt 1975 · S/N 28-7515359 N33746Lynch Ryan · Gilroy, CABuilt 1975 · S/N 28-7505175 N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3374ZKing Paul E · Albany, ORBuilt 1959 · S/N 18-7249 N33754Pietsch Aircraft Restoration And Repair Inc · Minot, NDBuilt 1975 · S/N 28-7515360 N33755Stearns Patricia M · Pooler, GABuilt 1975 · S/N 28-7505176 N33762Wits-Sims LLC · Canal Winchester, OHS/N 28-7525235

Back to AD 79-10-03 R2