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.

N21332Celmer Charles A · Puyallup, WABuilt 1972 · S/N 18261566 N21333Melius Ray D · Erda, UTBuilt 1972 · S/N 18261567 N21338N21338 LLC · Amarillo, TXBuilt 1972 · S/N 18261571 N21339Pilots Flying School LLC · Englishtown, NJBuilt 2003 · S/N 172S9551 N2133GPrice Bradley E · Sacramento, CAS/N 51433 N2133LGietzen Jeff · Seattle, WABuilt 2003 · S/N 18281287 N2133RLewis Christopher S · Hancock, MIBuilt 1964 · S/N 18255333 N2133YBullock John E Jr · Birdseye, INBuilt 1962 · S/N 17249633 N21343Bulger Thomas R · Oak Harbor, WABuilt 1972 · S/N 18261575 N21344Skylane Therapy LLC · Nampa, IDBuilt 1972 · S/N 18261576 N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933 N21348Nri Flying Club Inc · Walnut Creek, CABuilt 1972 · S/N 18261578 N2134MChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9552 N2134QLuft Aviation Inc · Wilmington, DEBuilt 1974 · S/N 177RG0534 N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775 N2134YHi Line Flying Club Inc · Seattle, WABuilt 1962 · S/N 17249634 N2134ZAvex Holdings Heli Inc · Lewes, DEBuilt 1963 · S/N 18051234 N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934 N21358Paroulek Joseph F · Milton, DEBuilt 1972 · S/N 18261585 N2135DN2135d LLC · Eustis, FLBuilt 2007 · S/N 18281899 N2135GCrawford Mark E · Pleasant Ridge, MIBuilt 1970 · S/N 15071682 N2135KJet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9556 N2135SEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 172S9558 N2135ZCapps Boyce Daniel · Newcastle, OKBuilt 1963 · S/N 18051235 N21360Weede Roger H · Dubois, WYS/N 17263935 N21362Joyce James R · Bellevue, WABuilt 1972 · S/N 18261587 N21368Alta Air LLC · Boise, IDBuilt 1972 · S/N 18261589 N21369Smk Holdings LLC · Sandy, UTBuilt 2003 · S/N 18281292 N2136GCulver Deborah M · Anchorage, AKBuilt 1958 · S/N 51436 N2136QStoneman Excav Co Inc · Ashland, VABuilt 1974 · S/N 177RG0536 N2136RGibbens John L Trustee · Rock Springs, WYBuilt 1964 · S/N 18255336 N21370Garner Jan L · Fremont, OHBuilt 1972 · S/N 18261591 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N21376Vodry John · Quilcene, WABuilt 1972 · S/N 18261596 N2137QInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0537 N2137RFreefall Express Inc · Gardiner, NYBuilt 1964 · S/N 18255337 N2137YCullinan David · Fryeburg, MEBuilt 1962 · S/N 17249637 N2137ZAnderson Kenneth L · Anchorage, AKBuilt 1963 · S/N 18051237 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561 N2138XSpencer Douglas J · Greenwood, CABuilt 1965 · S/N 337-0038 N21393Dinelli Aviation LLC · Milton, DES/N 18261607 N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449 N21395Faignant J Brian Jr · Anchorage, AKBuilt 1972 · S/N 18261608 N21396Greers Banner Air Of Bakersfield Inc · Bakersfield, CABuilt 1972 · S/N 18261609 N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339 N2139GSoarmates LLC · Missoula, MTBuilt 1958 · S/N 51439 N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339 N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448

Back to AD 79-10-14 R1