Skip to content

Registered aircraft · 40,394

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.

N9310HLilienthal Donald W · Cyrus, MNBuilt 1975 · S/N 17266080 N9310JBuckwalter Russell · Broadway, VABuilt 1966 · S/N 28-3403 N9311DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1958 · S/N 22-6322 N9311JSentelle Amanda L · Frederick, MDBuilt 1966 · S/N 28-3404 N9311VRegistration Pending · Queen Creek, AZRegistration pendingBuilt 1969 · S/N 690090 N9312DMcdonald Steve W · Lino Lakes, MNBuilt 1958 · S/N 22-6323 N9313CWright Terrence Richard · Tiffin, OHBuilt 1978 · S/N 28-7816459 N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081 N9313JLockhart Michael B · Redlands, CABuilt 1966 · S/N 28-3406 N9313KStauffer Donald R Jr · Tracy, CABuilt 1976 · S/N 28-7690241 N9314DCallahan Ashton G · Homer, AKBuilt 1958 · S/N 22-6325 N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220 N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118 N9315ESmith Mark S · Cornville, AZS/N 17272221 N9315JKruthoff Bret · Charles City, IABuilt 1966 · S/N 28-3425 N9315SBradford Alvin L · Northville, MIBuilt 1974 · S/N M-1596 N9315VGroff Joseph J · Colfax, CABuilt 1969 · S/N 690092 N9316JStennis Aviation Group LLC · Mandeville, LABuilt 1966 · S/N 28-3409 N9316MSale Reported · Kalispell, MTSale reportedBuilt 1966 · S/N 670001 N9317VSpaghetti Aviation LLC · Derby, KSBuilt 1969 · S/N 690093 N9318BAnderson Daniel R · Venus, TXS/N 172RG0790 N9318CTarakji Mohamad Hani A · Van Nuys, CABuilt 1978 · S/N 28-7890398 N9318JJohnson Matt · Eugene, ORBuilt 1966 · S/N 28-3411 N9319DCloud Buster LLC · Bloomfield, IABuilt 1958 · S/N 22-6332 N9319HHoffman Stanley L Jr · Bethel, AKBuilt 1975 · S/N 17266084 N9319JAcs Aviation LLC · Wilmington, DEBuilt 1966 · S/N 28-3427 N9319SMeyn Joseph · San Antonio, TXBuilt 1975 · S/N M-1652 N931CELinke John H · Norfolk, NES/N 1502524CE N931JBPyxis Volare LLC · Winter Garden, FLBuilt 1997 · S/N 20328 N931MSColeman Aviation LLC · Livingston, TNBuilt 1968 · S/N 17257349 N931PKBewley Corey T · Midlothian, TXBuilt 1995 · S/N 3484 N931RGScates Gregory B · Melba, IDBuilt 1995 · S/N 21002 N931SHDodson International Parts Inc · Rantoul, KSBuilt 2005 · S/N 3890 N931ZMason Fred B · Waterford, OHBuilt 1968 · S/N SE-1 N9320HPlane Tail LLC · Bethany, CTBuilt 1975 · S/N 17266085 N9320MMoreau Donald G · Dayton, TXBuilt 1966 · S/N 1252 N9321CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 28R-7837191 N9321DNiec Casmier M · Clio, MIFirst renewal noticeBuilt 1958 · S/N 22-6334 N9321JR Goldburg LLC · Gastonia, NCBuilt 1966 · S/N 28-3414 N9322DHitchcock Mark J · Scottsdale, AZBuilt 1958 · S/N 22-6335 N9322JZollitsch Allan P · Lancaster, NYBuilt 1966 · S/N 28-3415 N9322RNickname LLC · Scappoose, ORBuilt 1993 · S/N 2311 N9323ESchock Richard F II · Peoria, ILBuilt 1979 · S/N 17272226 N9323JDaissaoui Anouar · Quincy, MABuilt 1966 · S/N 28-3416 N9324DRegistered aircraftBuilt 1958 · S/N 22-6337 N9324JAdbdelsalam Moustafa · Buena Park, CABuilt 1966 · S/N 28-3417 N9324KBellew Philip H · Gadsden, ALBuilt 1976 · S/N 28-7690243 N9325VJaa Holdings LLC · Springfield, ILS/N 690096 N9326DAll Seasons Aviation LLC · Laredo, TXBuilt 1982 · S/N 172RG1122 N9326EWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 17272228

Back to AD 79-10-03 R2