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.

N3643XBurbey Mark G · Racine, WIS/N 301 N3644KDraheim Allan C · Lagrange, GABuilt 1967 · S/N 28-23663 N3644PHanselmann Seth · Lincoln, VTFirst renewal noticeBuilt 1955 · S/N 22-3395 N3644RRegistration Pending · Sarasota, FLRegistration pendingBuilt 1969 · S/N 28-5742 N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516 N3645XAubrey James M · North Little Rock, ARBuilt 1968 · S/N 302 N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518 N3647KRayman Bethany A · Salem, SDS/N 28-23666 N3647PHubbard Robert Thomas · Atlanta, GABuilt 1955 · S/N 22-3398 N3647RRegistration Pending · Indianapolis, INRegistration pendingBuilt 1970 · S/N 28-5744 N3648KBonanno John W · Oceanside, NYBuilt 1967 · S/N 28-23667 N3648ZMow The Sky LLC · Midway, UTBuilt 1960 · S/N 22-7545 N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519 N3649PHelmer Daniel W · Eagle, AKBuilt 1955 · S/N 22-3400 N3649RCummings Jason M · San Rafael, CABuilt 1969 · S/N 28-5746 N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354 N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776 N364HKoberg Lance L · Dallas, GABuilt 1974 · S/N 364 N364MNakamura Hajime Trustee · Long Beach, CAS/N 0364 N3650RScd Medical LLC · Alexandria, LABuilt 1969 · S/N 28-5747 N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520 N3651ZCrabtree Glenn E · Guthrie, OKBuilt 1960 · S/N 22-7548 N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756 N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025 N3653PWright Michael · Hurricane, UTS/N 22-3404 N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758 N3653ZMandibles Edward Jr · Lompoc, CABuilt 1960 · S/N 22-7550 N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521 N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673 N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759 N3655NPeterson Jesse D · Wasilla, AKBuilt 1947 · S/N 12-1906 N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513 N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522 N3656PKennedy Lukas · Anchorage, AKS/N 22-3407 N3657NEstes Aviation LLC · Vicksburg, MSBuilt 1967 · S/N 680027 N3657QFaith Builders Family Church Inc · Rogers, ARBuilt 1968 · S/N M-1136 N3657ZBagdon Albert B · Elbert, COBuilt 1960 · S/N 22-7554 N36583Trident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7816647 N36594Hayward Casey W · Anchorage, AKBuilt 1973 · S/N 578-73 N3659KDumont Mark · Brush Prairie, WABuilt 1967 · S/N 28-23676 N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320 N3659RInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-5762 N3659XAiello Bailey H · Eugene, ORBuilt 1968 · S/N 311 N365BSHarders Justin M · Cairo, NEBuilt 2024 · S/N 009 N365CB.R.S. Leasing Inc · Wilmington, DEBuilt 2001 · S/N 2163 N365CCSki Sawmill Family Resort Inc · Ulysses, PABuilt 2004 · S/N 9963CC N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033 N365PSFainer Jeffrey M · San Diego, CABuilt 1978 · S/N AA5A0552 N365RWWalter Aviation · Perry, IABuilt 1990 · S/N 903 N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671

Back to AD 79-10-03 R2