Skip to content

Registered aircraft · 17,028

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.

N8340LHess Garrett J · Fullerton, CABuilt 1968 · S/N 17256540 N8340MBlake Larry Q · Suwanee, GABuilt 1969 · S/N A1500040 N8340ZInstant Equity Auto LLC · Boise, IDS/N 205-0340 N8341MKab Aviation LLC · Cassopolis, MIBuilt 1969 · S/N A1500041 N8342MStreeter Wyatt E · Hanford, CABuilt 1969 · S/N A1500042 N8342SSkydive Northstar LLC · Mankato, MNBuilt 1965 · S/N 18256442 N8343MDuke Kay L · Darrouzett, TXBuilt 1969 · S/N A1500043 N8343SMcgowan Jon G · Northfield, MABuilt 1965 · S/N 18256443 N8343ZBybee Don R · La Center, WABuilt 1963 · S/N 205-0343 N8344GDonat Brandon L · Glendale, AZS/N 15062444 N8344LHeir Borne Flying Club Inc · Minot, NDBuilt 1968 · S/N 17256544 N8344SDouble Nickel Recycling LLC · Perryville, MOS/N 18256444 N8344ZMccoy Dell K · Aurora, ILBuilt 1963 · S/N 205-0344 N8345MBryant William G · Kenai, AKS/N A1500045 N8345SOlsen H Peter Jr · Fallon, NVBuilt 1965 · S/N 18256445 N8345U45u Leasing LLC · Beavercreek, OHBuilt 1964 · S/N 17252245 N8346GN8346g LLC · Fort Pierce, FLBuilt 1965 · S/N 15062446 N8346JHodgman Robert J · Yakima, WABuilt 1967 · S/N 15066246 N8346LJones Mark B · Angleton, TXBuilt 1968 · S/N 17256546 N8346ZHerrick William L · Howell, MIBuilt 1963 · S/N 205-0346 N8347GKeyes Mitchell R · Cornelius, NCBuilt 1965 · S/N 15062447 N8347LSchye Ted E · Billings, MTBuilt 1968 · S/N 17256547 N8347SShaffer Dyke T · Santa Rosa, CABuilt 1965 · S/N 18256447 N8347ULeupp Matthew C · Canal Winchester, OHS/N 17252247 N8348LPrice William B · Lamar, SCBuilt 1968 · S/N 17256548 N8349MMarker Nathan E · Amherst, OHBuilt 1969 · S/N A1500049 N8349UMassey Jay C · Mineral Wells, TXBuilt 1964 · S/N 17252249 N8350JSustarich Stephen M · Ketchikan, AKS/N 15066250 N8350SRegistration Pending · Wheatland, CARegistration pendingBuilt 1965 · S/N 18256450 N8350UColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17252250 N8351JRkd Aviation Services Inc · Dallas, TXBuilt 1967 · S/N 15066251 N8351LPlane Junkies LLC · Dover, DEBuilt 1968 · S/N 17256551 N8351MWheaton Eric J · Gig Harbor, WAS/N A1500051 N8351URappa Colin C · Nazareth, PAS/N 17252251 N8352JByrds Wholesale Inc · Clayton, NCS/N 15066252 N8352LFielding David · Scarborough, MES/N 17256552 N8352MOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1969 · S/N A1500052 N8352SMacwilliamson Roger · Hollister, CABuilt 1965 · S/N 18256452 N8352UVirani Shamshuddin · Fayetteville, GAS/N 17252252 N8353GHove Jeffrey P · Saint Paul, MNBuilt 1965 · S/N 15062453 N8353ZMccoy Jesse Jacob · Cabot, ARBuilt 1963 · S/N 205-0353 N8354LEast Texas Imperial Petroleum LLC · Flint, TXBuilt 1968 · S/N 17256554 N8354SNorthrop Kimberlei A · Spokane, WABuilt 1965 · S/N 18256454 N8354UErvin Jerome · Lometa, TXBuilt 1964 · S/N 17252254 N8355GGrant Jimmy L · Ada, OKBuilt 1965 · S/N 15062455 N8355JPadilla Hector F · Mountain View, CABuilt 1967 · S/N 15066255 N8355MRcs Services LLC · California, MDFirst renewal noticeBuilt 1969 · S/N A1500055 N8355SFayette Hawks Flying Club Inc · Somerville, TNBuilt 1965 · S/N 18256455 N8356MSporie George F · Marinette, WIBuilt 1969 · S/N A1500056 N8356SHirlinger Saylor John Trustee · Stevenson Ranch, CABuilt 1965 · S/N 18256456

Back to AD 72-03-03 R3