Skip to content

Registered aircraft · 17,027

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

N371LSatellite Flying Club Inc · East Patchogue, NYBuilt 1970 · S/N 17701488 N371RSStroberg Roger D · Hutchinson, KSBuilt 1966 · S/N 17254229 N371SRHurt David · Shallotte, NCBuilt 1966 · S/N 17256111 N3720FRegistration Pending · Chantilly, VARegistration pendingBuilt 1966 · S/N 17255215 N3720LWonsyld Erik · Grants Pass, ORBuilt 1965 · S/N 17253889 N3721LFlightmaster Aviation Services Inc · Centerville, INBuilt 1965 · S/N 17253890 N3721RMoran William J · Keller, TXBuilt 1966 · S/N 17255521 N3721UDanko Lawrence G Trustee · Paden, OKBuilt 1963 · S/N 18255121 N3722FHutchinson Flying Club LLC · Freeman, SDBuilt 1966 · S/N 17255217 N3722RRegistration Pending · Wallace, NCRegistration pendingS/N 17255522 N3722UDudash George M · Escondido, CABuilt 1963 · S/N 18255122 N3723JKerns Kenneth E · Collinsville, OKBuilt 1966 · S/N 15065023 N3724FRapp Timothy · Fairfield, MTBuilt 1966 · S/N 17255219 N3724LSnyder Brent I · Columbus, OHBuilt 1965 · S/N 17253893 N3724URouter Bit Service Co Inc · High Point, NCBuilt 1963 · S/N 18255124 N3726RJrs Appliance Disposal Inc · Inver Grove Hts, MNBuilt 1966 · S/N 17255526 N3727FCoray David A · Soldotna, AKBuilt 1966 · S/N 17255222 N3727JAerowood Aviation LLC · Monroe, NCBuilt 1966 · S/N 15065027 N3727LMoyer David J · Middletown, DEBuilt 1965 · S/N 17253896 N3728F316 Aviation LLC · Saint Clair Shores, MIBuilt 1966 · S/N 17255223 N3728JSpo Aviation LLC · Eufaula, OKBuilt 1966 · S/N 15065028 N3728LN3728l LLC · Statesville, NCBuilt 1965 · S/N 17253897 N3728RRaks Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 17255528 N3728UMaupin Daniel D · Corvallis, ORBuilt 1963 · S/N 18255128 N3728YPrt Aviation Corp · Wilmington, DEBuilt 1963 · S/N 21058228 N3729FPena Miguel A · Live Oak, FLS/N 17255224 N3729LWells Timothy P · Raynham, MAS/N 17253898 N372DRees Ryan G · Loa, UTS/N 15070466 N3730RChief Joseph Flyers Inc · Joseph, ORBuilt 1966 · S/N 17255530 N3730UWarren Kevin · Berger, MOBuilt 1963 · S/N 18255130 N3731LSturguess James K · Boonville, MOS/N 17253900 N3731YHaglin Dana · Erie, COBuilt 1963 · S/N 21058231 N3732LSumma Dawn K · Medina, OHBuilt 1965 · S/N 17253901 N3732UGifford Tracy G · Stephenville, TXBuilt 1963 · S/N 18255132 N3733FBurch Samuel Owen · Roxboro, NCBuilt 1966 · S/N 17255228 N3733LHillstrom Rudolph A · Oakville, WABuilt 1965 · S/N 17253902 N3733RCouick Donald Michael · Monroe, NCBuilt 1966 · S/N 17255533 N3733YHolliday Ivan Scott · Poplarville, MSBuilt 1963 · S/N 21058233 N3734JTrue Course LLC · Honolulu, HIBuilt 1966 · S/N 15065034 N3734LBertrand Todd A · Anchorage, AKBuilt 1965 · S/N 17253903 N3735FEb Flight Training LLC · Daytona Beach, FLBuilt 1966 · S/N 17255230 N3735JPetersen Kenton D · Jefferson, SDBuilt 1966 · S/N 15065035 N3736UDelong Don R · Wheeler, MIBuilt 1963 · S/N 18255136 N3738LTran Tuan M · Canton, MIBuilt 1965 · S/N 17253907 N3738YAirborne Solutions Group LLC · Dayton, OHBuilt 1963 · S/N 21058238 N3739FSchlueter Helmuth K · San Tan Valley, AZS/N 17255234 N3739LMattson David G · Lake Park, MNBuilt 1965 · S/N 17253908 N3739RRusak Robert J · Paris, TXBuilt 1966 · S/N 17255539 N3739UYown Inc · Ethridge, MTBuilt 1963 · S/N 18255139 N3739YCessna 210 LLC · Ogden, UTBuilt 1963 · S/N 21058239

Back to AD 72-03-03 R3