Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N2112YColorado Flight Center Inc · Grand Junction, COBuilt 1962 · S/N 17249612 N21132Holmberg Devon A · Anchorage, AKBuilt 1972 · S/N 18261437 N21137Tail Aero Corp · Wilmington, DEBuilt 1972 · S/N 18261439 N2113FBunde Kermit A · Pocatello, IDBuilt 1964 · S/N U206-0313 N2113JAlternate Air Inc · Seattle, WABuilt 1975 · S/N 17264982 N2113RStrong Tower Aviation LLC · Trenton, FLS/N 18255313 N21140Rabroker Stephen L · Carrollton, TXBuilt 1972 · S/N 18261441 N21145Regal Equipment LLC · Coarsegold, CABuilt 1972 · S/N 18261444 N21146Metzger Leesa A · Claypool, INBuilt 1972 · S/N 18261445 N21148Christoph Ryan M · Omak, WABuilt 1972 · S/N 18261447 N2114QJet Air Inc · Iowa City, IABuilt 2004 · S/N 172S9616 N2114UBravo Zulu Aviation LLC · Torrance, CAS/N 172S9618 N2114XGsi Corp · Eastham, MABuilt 1970 · S/N 17259495 N21150Smith Timothy L Trustee · Gig Harbor, WABuilt 1972 · S/N 18261448 N21157Beta Fleet LLC · South Burlington, VTBuilt 1974 · S/N 17263901 N21158Cbkg Holdings LLC · Chelsea, ALBuilt 1972 · S/N 18261453 N21159Kope Gregory A · Leesburg, VABuilt 1974 · S/N 17263902 N2115DRaykowski Michael J · Lake Elmo, MNBuilt 1979 · S/N 26630 N2115GBroeske Ian D · Windsor, CABuilt 1958 · S/N 51415 N2115KLiprie Randal C · Lake Charles, LABuilt 2004 · S/N 18281322 N2115MRedman Company LLC · Troy, MIBuilt 1972 · S/N 177-01703 N2115YDavis Rodney E · Nanty Glo, PABuilt 1962 · S/N 17249615 N21162Walton Jack W · Willcox, AZBuilt 1972 · S/N 18261456 N21163Jet Mic LLC · Blossom, TXBuilt 1972 · S/N 18261457 N2116RS&H Aviation LLC · Myrtle, MSBuilt 1964 · S/N 18255316 N21171Maggio Joseph · Sparta, NJBuilt 1972 · S/N 18261461 N21172Jk Aviation LLC · Sioux City, IABuilt 1972 · S/N 18261462 N21174Registration Pending · Atlantic Beach, FLRegistration pendingBuilt 1973 · S/N 18261464 N21176Gades Gary A · Montevideo, MNBuilt 1972 · S/N 18261465 N21177Valiair Lc Trustee · Casper, WYBuilt 1970 · S/N 177-01578 N21178Park Rodney D · Boring, ORBuilt 1972 · S/N 18261467 N21179Blakey Tammy S · Arlington, WABuilt 1972 · S/N 18261468 N2117FHelms Stephen · Anchorage, AKBuilt 1964 · S/N U206-0317 N2117QGately Brian · Brooklyn, NYBuilt 1974 · S/N 177RG0517 N2117RAlt Oliver B · Newberry, FLBuilt 1964 · S/N 18255317 N2117ZDe Schweinitz Christian R · Anchorage, AKBuilt 1963 · S/N 18051217 N21180L&W Leasing LLC · Murfreesboro, TNS/N 172S9624 N21181Chef Force One Aviation LLC · Miami Beach, FLBuilt 1972 · S/N 18261470 N21184N21184 LLC · Monticello, MNBuilt 1972 · S/N 18261471 N21189Axxo LLC · Flagstaff, AZBuilt 1972 · S/N 18261473 N2118GKohlhase Amy M · Anchorage, AKBuilt 1958 · S/N 51418 N2118LIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280676 N2118RKopecki Carin E · Hobson, TXFirst renewal noticeBuilt 1964 · S/N 18255318 N2118SAbes Erika · El Paso, TXBuilt 1975 · S/N 21061081 N2118YS&G Enterprise Inc · Owensville, INBuilt 1962 · S/N 17249618 N21191Schrott Bradley S · Federal Way, WABuilt 1972 · S/N 18261475 N21192Aaa Auto Salvage Inc · High Point, NCBuilt 1972 · S/N 18261476 N21193Krueger Scott M · Salem, SCBuilt 1972 · S/N 18261477 N21196Ashurst Richard J · Westmorland, CABuilt 1972 · S/N 18261478 N21198Jackie Hood Farms LLC · Moulton, ALBuilt 2005 · S/N 18281647

Back to AD 79-10-14 R1