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.

N4199LSarkisian Arthur · Woodstock, GABuilt 1966 · S/N 17254268 N419CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12348 N419EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12278 N419FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11446 N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787 N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659 N41AFAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1965 · S/N 17253102 N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980 N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890 N41FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272997 N41MEFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17269389 N42007Southeastern Oklahoma State University · Durant, OKBuilt 1999 · S/N 17280744 N4200FVanhorne John W · Everett, WABuilt 1958 · S/N 46100 N4200LDewey Michael C · Deer Island, ORBuilt 1966 · S/N 17254269 N4201QReeve Ryan · Hurricane, UTBuilt 1971 · S/N 17260101 N42024White Wings Air Inc · Jacksonville, FLBuilt 1974 · S/N 17264153 N4202LAa-Aero LLC · Fairfield, NJBuilt 1999 · S/N 17280747 N4202QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260102 N42033State Of Alaska · Anchorage, AKBuilt 1974 · S/N 17264154 N42035Paulsen Hans J · Cedartown, GABuilt 1974 · S/N 17264155 N4203FWindham Air LLC · Oxford, FLBuilt 1958 · S/N 46103 N4203PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 17280748 N4203QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260103 N4204FStephani Timothy M · White Lake, WIS/N 46104 N4204LMarquis Kim R · Poplar Bluff, MOBuilt 1966 · S/N 17254273 N4205FMunoz Randy · Aledo, TXBuilt 1958 · S/N 46105 N4205LKay Bennie L · Brigham City, UTBuilt 1966 · S/N 17254274 N42061Muhle Gerald A · Lincoln, NEBuilt 1974 · S/N 17264156 N42062Parker Jo K Trustee · Ardmore, OKBuilt 1974 · S/N 17264157 N4206QOsmonovich Michael · Kent, WABuilt 1971 · S/N 17260106 N4207LGlaude Jason T · Scarborough, MEBuilt 1966 · S/N 17254276 N4208LHowell Jerry C · Deatsville, ALBuilt 1966 · S/N 17254277 N42095Cpkb · Summit, NJBuilt 1974 · S/N 17264158 N4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIBuilt 1971 · S/N 17260109 N420ERAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280634 N420SPWings Over Texas Holdings LLC · Denton, TXBuilt 2000 · S/N 172S8351 N420URcs Services LLC · California, MDBuilt 1997 · S/N 17280120 N4210FOsterhouse Daniel E · Mattawan, MIBuilt 1958 · S/N 46110 N4210QKoehn Jerome D · Fairview, OKBuilt 1971 · S/N 17260110 N42111Blanchfield Christine Lizabeth · Devils Lake, NDBuilt 1974 · S/N 17264159 N42117Sturdivant Marshall J · Ellijay, GABuilt 1974 · S/N 17264160 N4211QJwmp Air Inc · East Moriches, NYBuilt 1971 · S/N 17260111 N42126Zrelak Patrick · Apple Valley, CABuilt 1974 · S/N 17264162 N4213LBuenrostro Paul · Burney, CAS/N 17254282 N4213QFogarty Aviation Inc · Wasilla, AKBuilt 1971 · S/N 17260113 N4214QMms Aircraft Leasing LLC · Williamsburg, VABuilt 1971 · S/N 17260114 N4215FBoss Brothers Aviation LLC · Buffalo, MOBuilt 1958 · S/N 46115 N4216LN4216l LLC · Kapolei, HIBuilt 1966 · S/N 17254285 N4218FPerry Michael C · Edgewater, FLS/N 46118 N4218LWengs Enterprises Inc · Tustin, CABuilt 1966 · S/N 17254287

Back to AD 90-06-03 R1