Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N94148Gates Don · Richmond Hill, GABuilt 1974 · S/N 21060519 N9414CPohland William C · Anchorage, AKBuilt 1955 · S/N 31812 N9414XSproul Lee E Jr · Lincoln, RIBuilt 1961 · S/N 21057714 N9415MCool Creek Aviation LLC · New Orleans, LABuilt 1976 · S/N 18264745 N9415XGarcia-Koren Maria J Personal Representative · Albuquerque, NMS/N 21057715 N9417XBentley Ross M · Saint Helena, CABuilt 1961 · S/N 21057717 N9418CWilliams Steven C · Anchorage, AKBuilt 1955 · S/N 31816 N9418M4 Blades Inc · Granada Hills, CABuilt 1976 · S/N 18264748 N9419HDedman Basil I · Cypress, CABuilt 1981 · S/N 18267945 N9419TPieper Mike D · Chandler, OKBuilt 1960 · S/N 57219 N941BMGk Transportation LLC · Clarksville, TNBuilt 1998 · S/N 18280408 N941CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281941 N941SBSarasota Seabreeze Flyers Inc · Venice, FLBuilt 2026 · S/N 18283346 N941WMEggert Jonathan Albert · Keizer, ORS/N 18266420 N94202Gilsdorf David R Trustee · Pleasant Hill, MOBuilt 1974 · S/N 21060536 N94203Frasier Air Inc · Tulsa, OKBuilt 1974 · S/N 21060537 N94206Andrews Gordon Bruce · Ellicott City, MDBuilt 1974 · S/N 21060539 N9420CMccarroll Donald J · Villa Park, CABuilt 1955 · S/N 31818 N9420MSideline Services LLC · Pearland, TXBuilt 1970 · S/N 21059320 N9420RStarr William E · Eagle River, AKBuilt 1985 · S/N U20606860 N94211Jskp Enterprises LLC · Dover, DEBuilt 1974 · S/N 21060542 N94227Dodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N 21060549 N9422HFort Smith Flying Club Inc · Fort Smith, ARBuilt 1981 · S/N 18267946 N9422KFaulkner Harry E Jr · Bethel, AKS/N U20604395 N9422TGraves Frank C · Nocona, TXBuilt 1960 · S/N 57222 N9422XLittle Bird Airways LLC · Hamburg, NYBuilt 1962 · S/N 21057722 N9423MPaquette Ralph H Jr · Apalachin, NYBuilt 1976 · S/N 18264749 N94244Bryant Kenneth D · Black Diamond, WAS/N 21060559 N9424TGill Melvin L Jr · Nashville, TNS/N 57224 N9425CInternational Air Services Inc Trustee · Carson City, NVBuilt 1955 · S/N 31823 N9425TBlue Skies Flying Services LLC · Blandon, PABuilt 1960 · S/N 57225 N9425XOatney Jared C · South Hutchinson, KSBuilt 1985 · S/N 18268518 N94263Hitch Aviation Inc · Malta, MTBuilt 1974 · S/N 21060569 N94267Hop Props LLC · Houston, TXBuilt 1974 · S/N 21060571 N9426CBenson Fred B · Cle Elum, WABuilt 1955 · S/N 31824 N9426KO Max Aviation · Willowbrook, ILBuilt 1974 · S/N 21060572 N9426XBradley Brunhilde K Trustee · Litchfield Park, AZBuilt 1961 · S/N 21057726 N9427MWillthedrill LLC · Las Vegas, NVBuilt 1976 · S/N 18264751 N94285Great Lakes Enterprises · Heron, MTBuilt 1974 · S/N 21060584 N9428CJones Kathleen W · Springfield, ORBuilt 1955 · S/N 31826 N9428GSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N U20601628 N9429CLanham Rex E Jr · Boise, IDBuilt 1955 · S/N 31827 N9429XWorld Missions Outreach · Brownsville, TXBuilt 1985 · S/N 18268521 N942JMPogany Steve C · Chugiak, AKBuilt 1976 · S/N U20603365 N942SAWalker John A · Kotzebue, AKS/N TU2060553 N942SMMackie Jonathan M · Manistique, MIBuilt 1969 · S/N T210-0416 N94303Nelson Ryan L · League City, TXBuilt 1978 · S/N 18266404 N94304Hamilton Francis D III · Olney, TXBuilt 1978 · S/N 18266405 N9430CRoberts Creek Holdings LLC · Bakersfield, CABuilt 1955 · S/N 31828 N9430TRmb Leasing Inc · Dover, DEBuilt 1960 · S/N 57230

Back to AD 84-10-01 R1