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.

N9162PBrown Nathan B · Wallace, KSBuilt 1966 · S/N 24-4650 N9163CZaparovanny Alexey · Westford, MABuilt 1995 · S/N 27-0208 N9163PMiller Richard Marc Trustee · Dana Point, CABuilt 1966 · S/N 24-4651 N9164ZN9164z LLC · Fayetteville, GABuilt 1996 · S/N 27-0213 N9166PNewman Jeffrey M · Pauline, SCBuilt 1966 · S/N 24-4654 N9167JNelson Ryan M · Appleton, WIBuilt 1994 · S/N 27-0168 N9167PPegasus Unlimited LLC · Arroyo Grande, CABuilt 1966 · S/N 24-4655 N9167YComanche Flyers Inc · Gig Harbor, WABuilt 1968 · S/N 31-220 N9169PPorter Christina · Cape Coral, FLS/N 24-4658 N916JAValiair Limited Co Trustee · Casper, WYBuilt 1993 · S/N 4622136 N916MCJanicke Kenneth O · Wichita, KSBuilt 2009 · S/N T18208914 N9170HWeight Steven A · Fairview Park, OHBuilt 1993 · S/N 27-0175 N9170PP&S Aviation LLC · White Rock, NMBuilt 1967 · S/N 24-4659 N9170RPage David L · Bermuda Dunes, CABuilt 1994 · S/N 27-0177 N9170XVb Inc · Show Low, AZBuilt 1989 · S/N 4622018 N9171PMckim Thomas F · Winston Salem, NCBuilt 1967 · S/N 24-4660 N91727Qualitair LLC Trustee · MichelstadtBuilt 1999 · S/N 27-0267 N9172PSale Reported · Henderson, NVSale reportedBuilt 1967 · S/N 24-4661 N91734Lejeune Walter R III · Clarksville, TNS/N 4622040 N9174NPool Aaron · Houston, TXBuilt 1989 · S/N 4622054 N9175SMarshall Adam A · Fremont, NEBuilt 1967 · S/N 24-4664 N9176GQs Aviation LLC · Laredo, TXS/N 4622055 N9176PWalter Richard · Hampshire, ILBuilt 1967 · S/N 24-4665 N9177Chaffin Christopher · Flower Mound, TXBuilt 1972 · S/N 3125 N9177PCochran Charles M III · Terre Haute, INBuilt 1967 · S/N 24-4666 N9178PCarnes Harley · Ocean, NJBuilt 1967 · S/N 24-4668 N917CFN917cf LLC · Tucson, AZBuilt 2005 · S/N T20608523 N917GTCentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-983-24 N917SELarson Donald C · Evanston, WYBuilt 1989 · S/N 27-0048 N9180PHughes Travis · Willow Park, TXBuilt 1967 · S/N 24-4670 N9180XInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 4622075 N9182PMonske Nicholas · Austin, TXS/N 24-4672 N9186NShrike One LLC · Deerfield Beach, FLBuilt 1972 · S/N 3131 N9187PJapundza Bob · Kokomo, INFirst renewal noticeS/N 24-4677 N9188PRogermoser Hanspeter · Summerville, SCBuilt 1967 · S/N 24-4678 N9189PThom Transport LLC · Marlette, MIBuilt 1967 · S/N 24-4680 N918ASFarley Scott S · Ellington, CTBuilt 1998 · S/N 3257029 N918CMRodriguez Eduardo Urquidi · Santa Teresa, NMBuilt 2001 · S/N T20608281 N91902Ebe Aviation LLC · Urbandale, IABuilt 1990 · S/N 4622094 N9190AAhlhorn Travis · New Braunfels, TXBuilt 1989 · S/N 32R-7887064 N9190PGreen Mark S · Ocala, FLBuilt 1967 · S/N 24-4683 N9193PDean Aaron · Norwich, NYBuilt 1967 · S/N 24-4686 N9193RLos Compadres Ranch · Premont, TXBuilt 1990 · S/N 4622098 N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688 N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689 N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690 N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692 N9199POther Woman LLC · Gulf Shores, ALBuilt 1990 · S/N 4622107 N919BTGeorges Thomas A · Santa Teresa, NMBuilt 1997 · S/N 27-0226 N919SPGorman Kevin V · Ebensburg, PABuilt 1999 · S/N 3257113

Back to AD 91-21-01 R1