Skip to content

Registered aircraft · 5,086

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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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.

N4167RZorychta Mary Ann · Clinton, ARBuilt 1968 · S/N 32-40483 N4167SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 3257153 N4168RJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 32-40484 N4168SDrew Dennis M · Danville, CABuilt 2000 · S/N 3257159 N4169RWollen Mark A · Poway, CABuilt 1968 · S/N 32-40566 N416GSB & K Travel LLC · Wilmington, DEBuilt 1975 · S/N 27-7554094 N4170VPi High Flight LLC · Lancaster, PABuilt 2000 · S/N 3257141 N4170WWilson Troy L · Raton, NMBuilt 1967 · S/N 32-40249 N4172RRedemption Inc · Kodiak, AKBuilt 1968 · S/N 32-40505 N4172TMajor Michael S · Ogden, UTBuilt 2000 · S/N 3257158 N4173AE Hospital Services Inc · Houston, TXFirst renewal noticeBuilt 2000 · S/N 3257146 N4173RWilliams Paul D · Gunnison, COBuilt 1968 · S/N 32-40507 N4173WGordon Jacques L Dmd · Atlanta, GABuilt 1967 · S/N 32-40252 N4174RSouth Butte LLC · Cedar City, UTBuilt 1968 · S/N 32-40508 N4174USouthern Siding And Window Corp · Augusta, GABuilt 2002 · S/N 3257308 N4174WAndrews Steven J · Warner Robins, GABuilt 1967 · S/N 32-40253 N4174ZCaledonia Air LLC · Palm Beach, FLBuilt 2000 · S/N 3257179 N4175KYu Christopher · Menlo Park, CABuilt 2000 · S/N 4636294 N4175WBauder Plane LLC · Hatfield, PABuilt 1967 · S/N 32-40255 N41769Tipton John H III · Chesterfield, MOBuilt 1974 · S/N 32-7440105 N4176TAir Ninja LLC · Wilmington, NCBuilt 1999 · S/N 3257124 N41799Registration Pending · Panama City Beach, FLRegistration pendingBuilt 2000 · S/N 4636257 N4179WCavada Arthur H · Jamul, CABuilt 1967 · S/N 32-40262 N417GTLs Aerospace Inc · Big Spring, TXBuilt 1974 · S/N 27-7405467 N417JMTulsa Aviation Partners LLC · Tulsa, OKBuilt 2000 · S/N 18280837 N417JSCockapoo Air LLC · Naperville, ILBuilt 1998 · S/N 4636183 N417RKAutavia Inc Trustee · Wilmington, DEBuilt 1999 · S/N 4636249 N4181WMission Flight · El Monte, CABuilt 1967 · S/N 32-40263 N4182AHidden Amphibians LLC · Dover, DES/N 3257182 N4182RSchmidt Tim A · Holdrege, NEBuilt 1968 · S/N 32-40513 N4182WNovember Four One Eight Two Whiskey LLC · Fulton, MOBuilt 1967 · S/N 32-40264 N4183WTate Aviation LLC · Camden, DEBuilt 2000 · S/N 3257183 N41847Saratoga N41847 LLC · Wilmington, DES/N 32-57165 N4184RB&S Air LLC · Palm City, FLBuilt 1968 · S/N 32-40517 N4184XM&N Aviation LLC · Carolina Beach, NCBuilt 2001 · S/N 3257200 N4185XWjw Transport Inc · Hampshire, ILBuilt 2000 · S/N 3257195 N41866Racy Equipment Leasing LLC · Tucson, AZBuilt 2000 · S/N 3257177 N41874Tailwinds Leasing LLC · Missoula, MTBuilt 1999 · S/N 4636230 N4187HMcalister Aviation LLC · Greenwood, ARBuilt 2000 · S/N 3257196 N4187QAggie80 Air LLC · Richmond, TXBuilt 2001 · S/N 3257214 N4187RAnkrum Donald Larry · Hemet, CABuilt 1968 · S/N 32-40522 N4188ASky Magic LLC · Helena, MTBuilt 2000 · S/N 4636296 N4188DMachine Leasing · Kent, WABuilt 1999 · S/N 4636220 N4189APelton Ag Inc · Burdett, KSBuilt 2003 · S/N 3255007 N4189RFarr Fly LLC · Wilmington, DEBuilt 1968 · S/N 32-40525 N4191WHowell Bo L · New Sharon, IABuilt 1967 · S/N 32-40276 N4192WPeters Karen L · Wanatah, INBuilt 1967 · S/N 32-40277 N4193WTurk Gerald L · Victor, MTBuilt 1967 · S/N 32-40279 N4195WSarvis Thomas · Bullhead City, AZBuilt 1967 · S/N 32-40283 N419RTPriddy Francis Wayne · Alvord, TXBuilt 1978 · S/N 32R-7887059

Back to AD 91-21-01 R1