Skip to content

Registered aircraft · 56,580

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.

N3037JMello Ben · Bainbridge Island, WAS/N 15061137 N3037QState Of Arizona · Holbrook, AZBuilt 1967 · S/N 18258037 N30384Knutson Wayne R · Thompson, NDS/N 15064473 N30387Watkins Bruce K · Houston, TXBuilt 1968 · S/N 17701226 N3038FTaylor Spencer H · Lake City, FLBuilt 1966 · S/N 18257138 N3038JPauls Flying Service LLC · Dundee, MSBuilt 1965 · S/N 15061138 N3038SAbove All Aviation · Goleta, CABuilt 1967 · S/N 15066938 N30390Rimmer Nathan S · Seattle, WABuilt 1968 · S/N 17701229 N30393Graden Timothy J · Polo, ILBuilt 1968 · S/N 17701231 N30396Sill John A · Cable, WIBuilt 1968 · S/N 17701233 N30399Schwanke Donald D · Springfield, ILBuilt 1968 · S/N 17701236 N3039VMiller Zachary L · Roseau, MNBuilt 1974 · S/N 15076364 N303BSLegacy Restoration Services Inc · Cumming, GABuilt 1980 · S/N 182-67622 N303CTFloyd Brian · Eatonton, GABuilt 1978 · S/N 21062591 N303EHNavigation Leasing LLC · Keizer, ORBuilt 2023 · S/N 172S13058 N303LKWestwind Aviation Inc · Bremerton, WABuilt 1973 · S/N 17262140 N303RHNavigation Leasing LLC · Kaizer, ORBuilt 2022 · S/N 172S12926 N303RJTr Zato Heir Land & Cattle LLC · Spur, TXBuilt 1970 · S/N 18501728 N303SDHarris County Sheriff'S Office · Spring, TXBuilt 1973 · S/N 18261849 N303SFSnohomish Flying Service Inc · Snohomish, WABuilt 2025 · S/N 172S13478 N303STVolar Vii LLC · Edmond, OKBuilt 2012 · S/N 172S11242 N303XStocki Ronald W · Centennial, COBuilt 1960 · S/N 52957 N30404Cardinal Flyers LLC · Powell, OHBuilt 1969 · S/N 17701237 N30407Cardinal Cronies LLC · Clarinda, IABuilt 1968 · S/N 17701238 N30409Schmitt Cameron · Fort Dix, NJBuilt 1968 · S/N 17701239 N3040FJump Tn LLC · Greeneville, TNBuilt 1966 · S/N 18257140 N3040JCrabtree Steven B · Canyon, TXBuilt 1965 · S/N 15061140 N3040SPearson Wayne L · Fayetteville, ARS/N 15066940 N3040VFlight Deck Air And Sea LLC · West Palm Beach, FLS/N 15076365 N3040YRight Rudder Flyers LLC · Columbia Falls, MTS/N 18254040 N30413Eagle Sky Patrol Inc · Deadwood, SDS/N 17701240 N30418Young Matthew B · Brighton, ILBuilt 1969 · S/N 17701244 N3041FRoffey Edward P Trustee · Grand Junction, COBuilt 1966 · S/N 18257141 N3041UMoser Paul J · Danville, PABuilt 1963 · S/N 17250641 N3041XSky Partners LLC · Sylacauga, ALBuilt 1966 · S/N 15064441 N30422Casey Michael B · Hemingford, NEBuilt 1976 · S/N 18503129 N3042FTdc Aviation LLC · Scottsdale, AZBuilt 1966 · S/N 18257142 N3042JHutchison Robert T · Big Lake, AKBuilt 1965 · S/N 15061142 N3042XMariani Nut Co Inc · Winters, CABuilt 1979 · S/N 18503903 N30433Flying Hawks Inc · Palmyra, WIBuilt 1968 · S/N 17701251 N30436Carson Charles E · North Vernon, INBuilt 1968 · S/N 17701252 N30437Richards David N · Port Matilda, PABuilt 1968 · S/N 17701253 N3043QDerango Gregory J · Chitina, AKBuilt 1967 · S/N 18258043 N3043XVaughan John T · Safety Harbor, FLBuilt 1966 · S/N 15064443 N30441Gillenwater Timothy J · Glasgow, KYBuilt 1968 · S/N 17701256 N30443Songer Harvey · Beech Grove, ARBuilt 1968 · S/N 17701257 N30444Crapnell Mark · Huntington Beach, CAS/N 210-58861 N30446Gumz Terry J · Wailuku, HIS/N 17701260 N3044QParrow Ronald J · Hampton, CTBuilt 1967 · S/N 18258044 N30450Recker Timothy J · Aurora, IABuilt 1968 · S/N 17701262

Back to AD 79-10-14 R1