Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N415WRN415wr LLC · Bogart, GAS/N 4636147 N4160NSteele Howard Scott · Idaho Falls, IDBuilt 2000 · S/N 4636280 N4162REckman Jason · Waterford, WIBuilt 1968 · S/N 32-40477 N4162WBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 32-40235 N4162ZSpirit Flyers Inc · Saint Louis, MOBuilt 2000 · S/N 3257127 N4163DMiraza Aviation LLC · Longview, TXBuilt 2000 · S/N 32-57145 N4163EAllied Aviators Inc · Allison Park, PABuilt 2000 · S/N 3257136 N4163PMalibu Aviation LLC · Bloomfield Hills, MIBuilt 2000 · S/N 4636274 N4163RFlying Javelina Aero-Club · Tucson, AZBuilt 1968 · S/N 32-40478 N4165LValiair Limited Co Trustee · Tucson, AZS/N 3257129 N41676American Roadways LLC · Missoula, MTBuilt 2000 · S/N 4636268 N4167AWilliams Mirage LLC · Denver, COBuilt 2000 · S/N 46-36254 N4167CSsp Aviation LLC · Aurora, OHBuilt 1999 · S/N 4636201 N4167DCraft Air Ventures LLC · Lake Jackson, TXBuilt 2000 · S/N 3257138 N4167NS&T Aviation LLC · Missoula, MTS/N 3257170 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

Back to AD 81-12-06 R1