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.

N578EREmbry Riddle Aeronautical University Inc · Prescott, AZS/N 172S13094 N578FGTextron Aviation Inc · Wichita, KSS/N 172S13642 N578MCChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 172S9578 N5790ASheen Mark Andrew · Snowflake, AZBuilt 1956 · S/N 28390 N5790RMiller Cindy C · San Ramon, CAS/N 17253459 N5790TViramontez Walter P · Santee, CABuilt 1964 · S/N 17251690 N5791TShinn Jeffrey D · Weatherford, TXBuilt 1964 · S/N 17251691 N5792RCollins Mark W · Seymour, TNBuilt 1965 · S/N 17253461 N5792TMorgan Dennis A · Middle River, MDBuilt 1964 · S/N 17251692 N5793RRogers Jesse E · La Belle, MOBuilt 1965 · S/N 17253462 N5793TJefferson County Public Schools · Louisville, KYBuilt 1964 · S/N 17251693 N5794APerkins Larry L · Wildomar, CAFirst renewal noticeBuilt 1956 · S/N 28394 N5794RMacfarland Donald C · North Tonawanda, NYBuilt 1965 · S/N 17253463 N5794TGodfrey Kenneth E · Oroville, CABuilt 1964 · S/N 17251694 N5797AEver Fast LLC · Kalispell, MTS/N 28397 N5797RRiggs Laura A · Middleburg, FLBuilt 1965 · S/N 17253466 N5798ABowman Ronald J · Bellefonte, PABuilt 1956 · S/N 28398 N5798RRatcliff Bruce A · Plain City, OHBuilt 1965 · S/N 17253467 N5799AMiller Lavon S · Eureka, NVS/N 28399 N5799TGs Air LLC · Sioux Falls, SDS/N 17251699 N579BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280944 N579JKKopacz Thomas H · Glen Flora, WIBuilt 1973 · S/N 17261765 N579KRed Plane Aviation LLC · Key West, FLBuilt 1960 · S/N 17247827 N579WGTrede 2021 C172 LLC · Aurora, ORBuilt 2021 · S/N 172S12752 N57BMHuerta Holdings Inc · Santa Ana, CABuilt 1973 · S/N 17261980 N57FASilver Express Co DBA · Miami, FLBuilt 1997 · S/N 17280225 N57FFWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 172S12927 N57MWFogal Brian K · Chambersburg, PABuilt 1957 · S/N 29688 N57UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12089 N57VBKlingebiel Kurt · Leonardtown, MDBuilt 1985 · S/N 17276476 N57WHMoon Richard B · Arizona City, AZBuilt 1976 · S/N 17267069 N5800ACarson A Jane · Vance, ALBuilt 1956 · S/N 28400 N5800CFreixas Enrique · Torrance, CABuilt 1957 · S/N 36435 N5800RPomeroy Cattle Ranch LLC · Kalispell, MTS/N 17253469 N5802RMiller Chris D · Collierville, TNBuilt 1965 · S/N 17253471 N5803EIrwin Donald L · Emporia, KSBuilt 1978 · S/N 17271938 N5804ASandall Evan R · Bonsall, CABuilt 1956 · S/N 28404 N5804RGriffin David Charles · Palmyra, PABuilt 1965 · S/N 17253473 N5805AVictory Aero Tech Inc · Camarillo, CABuilt 1956 · S/N 28405 N5807RYoung Darrin · Chillicothe, MOBuilt 1965 · S/N 17253476 N5809RJ L S Agency LLC · Starkville, MSBuilt 1965 · S/N 17253478 N580ETTrede 2023 LLC · Castle Rock, COBuilt 2023 · S/N 172S12990 N580SUMetro Aviation Inc · Shreveport, LABuilt 1981 · S/N 172RG0877 N5811AHayes Gareth E · Durham, NCBuilt 1956 · S/N 28411 N5811EMoss Jessee C · Ardmore, OKBuilt 1978 · S/N 17271941 N5811RGreat Plains Enterprises LLC · Wilmington, OHBuilt 1965 · S/N 17253480 N5812RPeterson Bruce G · Saint Cloud, MNBuilt 1965 · S/N 17253481 N5814RBrown Jacob M · Boswell, PABuilt 1965 · S/N 17253483 N5815RLambson Roger · Saint Ignatius, MTBuilt 1965 · S/N 17253484 N5816AMitzelfeldt James W · Stanwood, WABuilt 1956 · S/N 28416

Back to AD 90-06-03 R1