Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N3225LWing Nuts Inc · Maryville, MOBuilt 1967 · S/N 17256125 N3226LStammen Dakota J · Stanley, NDBuilt 1967 · S/N 17256126 N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475 N3227LLown Robin F · Douglas, AKBuilt 1967 · S/N 17256127 N3228LWoodson Marcus L · Detroit, MIBuilt 1967 · S/N 17256128 N3229LTate Samuel Paul Baylon · Tacoma, WABuilt 1967 · S/N 17256129 N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231 N322EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12782 N322JWBravo Aircfraft LLC · Alpharetta, GABuilt 2026 · S/N 172S13521 N3231LColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1967 · S/N 17256131 N3236LMartin Alan K · Tenaha, TXBuilt 1967 · S/N 17256136 N3237LKeith Investments LLC · Verona, MSBuilt 1967 · S/N 17256137 N3238ESwiss Jack S · Anchorage, AKBuilt 1978 · S/N 17271477 N3239ELeaf Air LLC · Queensbury, NYBuilt 1978 · S/N 17271478 N3239LGame Composites Flying Club · Bentonville, ARBuilt 1967 · S/N 17256139 N323FSFredericks Hall Aviation LLC · Mineral, VABuilt 1986 · S/N 17276547 N323SMAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260679 N3240LWooden Alan L · Signal Mountain, TNBuilt 1967 · S/N 17256140 N3241LDostroph Manfred J · Lewis Center, OHBuilt 1967 · S/N 17256141 N3244LKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1967 · S/N 17256144 N3245GDougherty Robert E · Mosheim, TNBuilt 1956 · S/N 28326 N3245LGift Academy Inc · Vernon, TXBuilt 1967 · S/N 17256145 N3246LStephens David J · Clarence, NYBuilt 1967 · S/N 17256146 N324CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12135 N324SPHagele Aviation LLC · Hillsboro, ORBuilt 1999 · S/N 172S8249 N3250LMiner Jess L · Emmet, NEBuilt 1967 · S/N 17256150 N3251LWiles David A · Ozark, ARBuilt 1967 · S/N 17256151 N3252LElizabethton Aerobatic Club Inc · Elizabethton, TNS/N 17256152 N3254CCoon Vernon Ray · Atmore, ALBuilt 1967 · S/N 17256156 N3254LSelby Thomas A · Fenton, MIBuilt 1967 · S/N 17256154 N3255LPatton Steven W · Fayetteville, ARS/N 17256155 N3257EFlycarolina LLC · Concord, NCBuilt 1978 · S/N 17271482 N3257LBeene Jerry · Bulverde, TXBuilt 1967 · S/N 17256157 N325SPTfs Air LLC · Loveland, COBuilt 1999 · S/N 172S8251 N3260LHerring Rhett H · College Station, TXBuilt 1967 · S/N 17256160 N3262LKd3262 LLC · Downers Grove, ILBuilt 1967 · S/N 17256162 N3263LSale Reported · Arcata, CASale reportedBuilt 1967 · S/N 17256163 N3265AMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9878 N3265ETa Brand LLC · Middletown, DEBuilt 1978 · S/N 17271483 N3266EN3266e LLC · Homestead, FLBuilt 1978 · S/N 17271484 N3266LWolverine LLC · Roanoke, VABuilt 1967 · S/N 17256166 N3267LBetter Fly Inc · Litchfield, ILS/N 17256167 N326EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13515 N326LPVista Aviation Inc · Pacoima, CAFirst renewal noticeBuilt 2003 · S/N 172S9326 N326MEAiry LLC · Seattle, WABuilt 2000 · S/N 172S8573 N3271LHenson Raul Andre · Fox Island, WABuilt 1967 · S/N 17256171 N3273EAnderson Thomas J · Big Bear City, CABuilt 1978 · S/N 17271486 N3274EBitzer John · Cologne, MNBuilt 1978 · S/N 17271487 N3274LHk Ventures LLC · Paynesville, MNS/N 17256174 N3275LMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 17256175

Back to AD 90-06-03 R1