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.

N419SWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 32-40284 N41TNBvbd Aviation LLC · Charlotte, NCBuilt 1980 · S/N 31-8012034 N4201RCrockett Guy S · Louisville, KYBuilt 1968 · S/N 32-40542 N4203RFier Michael A · Mundelein, ILBuilt 1969 · S/N 32-40568 N4204RVeal Tim S · Kenai, AKBuilt 1969 · S/N 32-40569 N4205BStasson Robert K · Sikes, LABuilt 1974 · S/N 75-32-146 N4205RMarking Refrigeration Inc · Omaha, NEBuilt 1969 · S/N 32-40570 N4206RTelevision Signal Distribution Specialists Inc · Canton, OHBuilt 1969 · S/N 32-40571 N4208RPeh Aviation LLC · Morristown, TNBuilt 1969 · S/N 32-40573 N4209RLo-Flyer 235 LLC · Boyle, MSBuilt 1969 · S/N 32-40574 N420ARArakelian Arthur DBA · Worcester, MABuilt 2000 · S/N 3257149 N4210MParagon Air Group · Fort Worth, TXBuilt 1998 · S/N T20608009 N4210RWalle Neil M · Klamath Falls, ORBuilt 1969 · S/N 32-40575 N4211RDyson Michael · Duxbury, MABuilt 1969 · S/N 32-40576 N4212RLetkeman Abram · Amarillo, TXBuilt 1969 · S/N 32-40577 N4213RClear Blue Skies Aviation LLC · Warner Robins, GABuilt 1969 · S/N 32-40578 N4216RJeffordspaul · Naperville, ILBuilt 1969 · S/N 32-40581 N42178Montana Dept Of Transportation · Helena, MTBuilt 1999 · S/N T20608032 N4218UJakks Inc · Wilmington, DEBuilt 1999 · S/N T20608035 N4219T19t LLC · Columbia, MOBuilt 1971 · S/N 32-7240037 N421KRAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N T18208308 N421TBHale Concepts LLC · Marietta, OHBuilt 2002 · S/N 2081 N4220RFoster Carl G · Tucson, AZBuilt 1969 · S/N 32-40585 N4220TMartin Thomas Arthur · Great Falls, VABuilt 1972 · S/N 32-7240057 N4226RClearview Farms LLC · Magnolia, NCBuilt 1969 · S/N 32-40591 N4228RRegistered aircraftBuilt 1969 · S/N 32-40593 N4228TSmith Jerry Wayne · Monroe City, INBuilt 1971 · S/N 32-7240046 N422MCWendt Michael · Tecumseh, NEBuilt 1977 · S/N 32-7740088 N422WBHbk LLC · Lynden, WABuilt 1977 · S/N 31-7752152 N4231RKearney Larry Neal · Graham, TXBuilt 1969 · S/N 32-40596 N4233R33 Romeo Inc · Wilmington, DEBuilt 1969 · S/N 32-40598 N4238RMarianas Air Transfer Inc · Saipan, MPBuilt 1969 · S/N 32-40603 N4239ADowden Frank · Fallbrook, CAS/N 32R-7885269 N4239RWilson John T · Castalian Springs, TNBuilt 1969 · S/N 32-40604 N423BMSouth Regional Aviation Enterprise Inc · Boynton Beach, FLS/N 3255022 N423JTSoutheast Air Tran LLC · Hahira, GABuilt 1994 · S/N 4622162 N423PSTabano Anthony · National Harbor, MDBuilt 2004 · S/N 27-0326 N4241RFsi Aviation LLC · San Antonio, TXBuilt 1969 · S/N 32-40606 N424BHTouchdown Arkansas LLC · Batesville, ARBuilt 1976 · S/N 32R-7780016 N424FARobinson Todd Allen · San Luis Obispo, CABuilt 2003 · S/N T20608424 N424PAviation Co LLC · Kaneohe, HIBuilt 1974 · S/N 31-7401222 N424RMEast End Grill Management Co LLC · Memphis, TNBuilt 1977 · S/N 32R-7780306 N424SBBsi Technologies II Inc · Richmond, VABuilt 1999 · S/N 27-0280 N424TPHarris Joseph · Bradenton, FLBuilt 1977 · S/N 32R-7780332 N424WHSchmidt Richard A · West Linn, ORBuilt 2004 · S/N T18208294 N4250RNewsome George W III · Palmyra, NYBuilt 1969 · S/N 32-40617 N4254RStar Marianas Air Inc · Saipan, MPBuilt 1969 · S/N 32-40625 N4259RThorn Robert L · Clovis, NMBuilt 1969 · S/N 32-40631 N425CAHowell Norman · Port Orange, FLBuilt 1977 · S/N 61P-0425-156 N4260RColin Irons Diving And Pool Service · Crawfordville, FLBuilt 1969 · S/N 32-40634

Back to AD 91-21-01 R1