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.

N3318FIsland Aero LLC · Tavernier, FLBuilt 1966 · S/N 18257318 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918 N331JCCsp Aviation Holdings LLC · Dallas, TXBuilt 1966 · S/N 15064821 N3320FPoock Jerry D · Spencer, IABuilt 1966 · S/N 18257320 N3320JPollman Justin A · Sherwood, NDS/N 15066020 N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920 N3321FOwl Aviation LLC · Kingsport, TNBuilt 1966 · S/N 18257321 N3321JFulton Ricky L · Alex, OKBuilt 1966 · S/N 15066021 N3321RGray Kerry L · Granbury, TXBuilt 1967 · S/N 18258621 N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621 N33220Advanced Analytical Inc · Newbury Park, CABuilt 1976 · S/N 177RG0925 N3322FCrystalline Entity · Los Angeles, CABuilt 1966 · S/N 18257322 N3322UPrecision Design Inc · Wilimington, DEBuilt 1963 · S/N 18254722 N3322YFostair Inc · Ovid, NYS/N 18254322 N33230Alaska Air Service LLC · Brookings, ORBuilt 1976 · S/N 177RG0930 N3323FFly The Dream LLC · Sun Prairie, WIBuilt 1966 · S/N 18257323 N3323JRichards Amy L · Union City, INBuilt 1966 · S/N 15066023 N3323RD&J Air Adventures Inc · Koloa, HIBuilt 1967 · S/N 18258623 N3323TDeese James K Jr · Charlotte, NCS/N 17700623 N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323 N33248Wilson Harvey Lee · Gadsden, ALBuilt 1976 · S/N 177RG0932 N3324UHaer Welton · Craig, MOBuilt 1963 · S/N 18254724 N3324YVoge Michael · Chino Hills, CABuilt 1962 · S/N 18254324 N3325RDresick Farms Inc · Huron, CABuilt 1968 · S/N 18258625 N3325UWeber Donald E · Saint David, AZS/N 18254725 N3326FRegistered aircraftBuilt 1966 · S/N 18257326 N3326RAnderson Patrick Alan · Ripley, WVS/N 18258626 N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626 N33272Explorco LLC · Evergreen, COBuilt 1976 · S/N 177RG0938 N33273Dahl Neil A · Arlington, TXBuilt 1976 · S/N 177RG0939 N33274Cooker Brian M · Gold Hill, NCBuilt 1976 · S/N 177RG0940 N3327RLyman Gregory A Trustee · Traverse City, MIBuilt 1967 · S/N 18258627 N3327SDavis Blake A · Bellevue, TXS/N 21059127 N3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAS/N 17700627 N33291Skyways Aviation Inc · Wilmington, DEBuilt 1976 · S/N 177RG0944 N33296Mob Aviation USA LLC · Auburndale, FLBuilt 1976 · S/N 177RG0946 N33297Skinner Marvin L · Mansfield, TXBuilt 1976 · S/N 177RG0947 N33299Business Jet Services Inc · Apopka, FLBuilt 1976 · S/N 177RG0948 N3329FFerguson Ryan L · Fort Collins, COBuilt 1966 · S/N 18257329 N3329UDirectional Holdings LLC · Missoula, MTBuilt 1963 · S/N 18254729 N332JCS&S Aircraft Inc · Bennington, VTS/N 17258514 N332JRAdair Lawrence L Jr · Fountain Run, KYBuilt 1961 · S/N 18253722 N3330FEmk Trans LLC · The Dalles, ORS/N 18257330 N3330UWolford Alyson · Bonney Lake, WABuilt 1963 · S/N 18254730 N3330YTighe Joseph E · Kingsland, TXBuilt 1962 · S/N 18254330 N3332TWilliams Darryl L · Medina, OHS/N 17700632 N3332UMing Greg A · Guymon, OKBuilt 1963 · S/N 18254732 N3333JUrban Aviation Services Inc · Paxton, MABuilt 1966 · S/N 15066033 N3333YDeville Charles D · Clinton, LABuilt 1962 · S/N 18254333

Back to AD 72-03-03 R3