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.

N6249SPurawic Jessica · Asheville, NCS/N 15067049 N624CGChristy Alan · Pendleton, ORBuilt 1966 · S/N 18257270 N6250RJennings Frederick T · Friona, TXBuilt 1965 · S/N 15061550 N6252GBoston Philip · Jacksonville, FLBuilt 1970 · S/N 15071752 N6253SShroyer Rex G · Philomath, ORBuilt 1967 · S/N 15067053 N6255GHaglbohm Jeffrey S · Helena, MTBuilt 1970 · S/N 15071755 N6257SHoffmeyer Scott D · Carson City, NVBuilt 1967 · S/N 15067057 N6258RCache River Flyers LLC · Greeley, COS/N 15061558 N6259GBartel Christopher H · Williamsburg, PAS/N 15071759 N6259RBreletic John C Jr · Ellijay, GABuilt 1975 · S/N 17702236 N6259SDavis Scott B · Quincy, ILBuilt 1967 · S/N 15067059 N625MBGood And Young LLC · Wilmington, DEBuilt 1964 · S/N 18255233 N6260RNichols Rylan A · Frazer, MTBuilt 1965 · S/N 15061560 N6260SBrowne Clifford B · Southport, MEBuilt 1967 · S/N 15067060 N6261GNagaruk Nathan J · Nome, AKBuilt 1970 · S/N 15071761 N6261QPitz William A · Mitchell, SDBuilt 1967 · S/N 17255080 N6261SWinnewisser Steve G · Santa Barbara, CABuilt 1967 · S/N 15067061 N6262GStockton Raymond L · Pearl City, HIS/N 15071762 N6262SSamis Kyle C · Emeryville, CABuilt 1967 · S/N 15067062 N6264GOdush & Sayush Inc · Aurora, ILBuilt 1970 · S/N 15071764 N6264RCencal Flyers LLC · Turlock, CABuilt 1965 · S/N 15061564 N6264SJohnson Eric C · Turtle Lake, NDBuilt 1967 · S/N 15067064 N6265GCastleman Thomas G · League City, TXBuilt 1970 · S/N 15071765 N6265SWilson Daniel · Bandon, ORBuilt 1967 · S/N 15067065 N6266Wheaton Eric J · Gig Harbor, WAS/N 15066879 N6266GArgintar Donald · Fair Lawn, NJBuilt 1970 · S/N 15071766 N6268SHayes Barrett W · Siler City, NCBuilt 1967 · S/N 15067068 N6269GMattingly Andrew R · New Albany, INBuilt 1970 · S/N 15071769 N626LDAerofleet LLC · Oldsmar, FLBuilt 1973 · S/N 177RG0341 N6270SHudson Kelly G · Monroe, NCBuilt 1967 · S/N 15067070 N6271GSumpter Kenneth W · Enid, OKBuilt 1970 · S/N 15071771 N6271SJay Square Aircraft Inc · Hilton Head Island, SCBuilt 1967 · S/N 15067071 N6272GDunn Michael Thomas · Arlington, VAS/N 15071772 N6277SJones Joseph L · Saint David, AZS/N 15067077 N6282SWorth William D · Huntington Beach, CABuilt 1967 · S/N 15067082 N6283RAkchak Air LLC · Leeds, UTBuilt 1965 · S/N 15061583 N6283SMorris Kristina T · Ventura, CABuilt 1967 · S/N 15067083 N62853Willkomm John C · Kenosha, WIBuilt 1974 · S/N 15075715 N6285SWindsor John R · East New Market, MDBuilt 1967 · S/N 15067085 N6286SCunningham Doris DBA · East Freetown, MABuilt 1967 · S/N 15067086 N6287GPeters Guy P · Roy, UTBuilt 1970 · S/N 15071787 N6288GFetter Stanley B · Accokeek, MDBuilt 1970 · S/N 15071788 N6289SLink Darryl B · Centennial, COBuilt 1967 · S/N 15067089 N628DKEastgate Investments LLC · Henderson, NVBuilt 1965 · S/N 18255786 N628RBBrown Michael C · Erie, KSBuilt 1972 · S/N 17260622 N628RGKozubek Richard R · Shady Shores, TXBuilt 1976 · S/N 177RG0992 N6290SFloyd Brannon A · Athens, GABuilt 1967 · S/N 15067090 N6291GWaddell Lucas A · Fort Worth, TXBuilt 1970 · S/N 15071791 N6292SAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1967 · S/N 15067092 N6294GGoodrich Michael O · Cogan Station, PABuilt 1970 · S/N 15071794

Back to AD 72-03-03 R3