Skip to content

Registered aircraft · 20,687

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.

N7702TNablo Dustin · Haddam Neck, CTS/N 47302 N7704XStark Linda L · Arroyo Grande, CABuilt 1960 · S/N 17248204 N7705UCaldwell Evan-James Gray · Camano Island, WAS/N 17251705 N7706XAircaft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1960 · S/N 17248206 N7707TAmerican Petro Inc · Ball Ground, GABuilt 1960 · S/N 47307 N7707UMeese Brian D · Conroe, TXBuilt 1964 · S/N 17251707 N7708UDahle Jacob J · Morristown, MNBuilt 1964 · S/N 17251708 N7710TMorton David W · Brady, TXBuilt 1960 · S/N 47310 N7710XGraves Robert D · Elberton, GABuilt 1960 · S/N 17248210 N7711TBaker Eddy · Waynesville, ILBuilt 1960 · S/N 47311 N7711UHaneline Douglas A II · Statesville, NCFirst renewal noticeS/N 17251711 N7712UGolding James M · Diamond Springs, CABuilt 1964 · S/N 17251712 N7713GDavenport Jimmy J · Hayesville, NCS/N 17259413 N7713THatton Daniel R · Portland, ORS/N 47313 N7713UDavisson Paul V · Jupiter, FLBuilt 1964 · S/N 17251713 N7714GGlynco Manning Aviation Inc · Brunswick, GABuilt 1970 · S/N 17259414 N7714UKimbrell Quentin · Cape Girardeau, MOS/N 17251714 N7714XLenhardt Edward J · Green Lane, PABuilt 1961 · S/N 17248214 N7715GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259415 N7715UFenton Dale R · New Bern, NCBuilt 1964 · S/N 17251715 N7716GFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259416 N7716UOpportune Entity LLC · Sanger, TXBuilt 1964 · S/N 17251716 N7717GJohnson Eric C · Turtle Lake, NDBuilt 1970 · S/N 17259417 N7717TGully Samuel Lee · Noxapater, MSBuilt 1960 · S/N 47317 N7717UGreen Castle Aero Club Ltd · Oxford, IABuilt 1964 · S/N 17251717 N7718URenninger Dustin L · Mc Veytown, PAS/N 17251718 N7719TRushton George Emery · Clinton, MIS/N 47319 N7720GZulu Jets LLC · Boerne, TXBuilt 1970 · S/N 17259420 N7720XJeter Thomas L · South Padre Island, TXBuilt 1960 · S/N 17248220 N7721GWurtsboro Airpark LLC · Wurtsboro, NYS/N 17259421 N7721TBourdon Alain · West Springfield, MABuilt 1960 · S/N 47321 N77222Davis Sam Alan · Wendell, NCBuilt 1973 · S/N 17262487 N7722GKnaack Roland · Cumming, GABuilt 1970 · S/N 17259422 N7722TPfc Aviation Repair Inc · Wallingford, CTS/N 47322 N7722UBeebout Shawn C · Milroy, MNBuilt 1964 · S/N 17251722 N7722XLeasure Everett D · Joliet, ILBuilt 1960 · S/N 17248222 N7723UAdams David C · Westford, MABuilt 1964 · S/N 17251723 N7724GWind Walker LLC · Tucson, AZBuilt 1970 · S/N 17259424 N7724XJohnson Randy G · Collinsville, OKBuilt 1960 · S/N 17248224 N7725UCvz-Vivace LLC · Fort Worth, TXBuilt 1964 · S/N 17251725 N7726XTop Profile Management LLC · Somis, CABuilt 1960 · S/N 17248226 N7727GSkyhawk Air LLC · Brunswick, GABuilt 1970 · S/N 17259427 N7727UWingtip Aviation LLC · Amarillo, TXBuilt 1964 · S/N 17251727 N7728GTakeflight LLC · Spanish Fork, UTBuilt 1970 · S/N 17259428 N7728UKropp Richard G · North Creek, NYBuilt 1964 · S/N 17251728 N7729GValiair Lc Trustee · Casper, WYBuilt 1970 · S/N 17259429 N7729UBlough Lynn M · Pittsburgh, PABuilt 1964 · S/N 17251729 N772FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13277 N772GKAmerican Aircraft Brokers LLC · Aurora, ORBuilt 2005 · S/N 172S9885 N772MSSchmidt Barnet M · Oradell, NJBuilt 1999 · S/N 172S8180

Back to AD 90-06-03 R1