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.

N915WCBarr Air Patrol LLC · Mesquite, TXBuilt 2003 · S/N T20608412 N9160NBoeing Co · Renton, WABuilt 1971 · S/N 3114 N9160PHeath Allen W · Westlake, TXBuilt 1966 · S/N 24-4648 N9160ZBriggs Robert B · Germantown, TNBuilt 1989 · S/N 4622023 N9161DSchlesinger Warren · Page, AZBuilt 1990 · S/N 270071 N9161EKurtz Andrew · Boise, IDBuilt 1990 · S/N 27-0068 N9161KSkymook Aviation LLC · Beaver Falls, PABuilt 1989 · S/N 4622022 N9161NCorvallis Rapid Transit LLC · Corvallis, ORBuilt 1999 · S/N 27-0266 N9161PAven Michael D · Georgetown, INBuilt 1966 · S/N 24-4649 N9161UHeron Kyle B · Modesto, CABuilt 1992 · S/N 27-0145 N9161YFonville David N · Cresson, TXBuilt 1992 · S/N 27-0146 N9162DWeagle Aviation LLC · Birmingham, ALBuilt 1993 · S/N 27-0152 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

Back to AD 81-12-06 R1