Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationBuilt 1968 · S/N 680077 N67648Flying Vikings Inc · Hayward, CABuilt 1978 · S/N 15281960 N6764NBiermann William W · Hollister, CABuilt 1968 · S/N 690001 N67651Salomonsson Mats · Fremont, CABuilt 1978 · S/N 15281963 N67652Final Design Group LLC · Hurricane, UTBuilt 1978 · S/N 15281964 N67657Jade Air LLC · San Pedro, CABuilt 1978 · S/N 15281965 N6765NBogdan Joseph H · Soper, OKBuilt 1968 · S/N 680088 N6766NFoley Erik J · Henderson, NVS/N 680079 N6767CSilverstein Devyn · Austin, TXBuilt 1967 · S/N 670130 N6767NEichhorn Tyler L · Paonia, COBuilt 1968 · S/N 680089 N6767VParmenter Micah J · Aurora, COBuilt 1970 · S/N 700059 N6768NPorthouse Chris · Bellingham, MABuilt 1968 · S/N 680080 N6768UBranson Randel L · Eclectic, ALBuilt 1963 · S/N 2490 N6769NCausey Kevin L · Bainbridge, GABuilt 1968 · S/N 680081 N6769UWard Leonard · Preston, IDBuilt 1963 · S/N 2491 N676CHTake Off Aviation Services LLC · Rockledge, FLBuilt 1976 · S/N 17266905 N676NLoftus Timothy P · Mclean, VABuilt 1968 · S/N 680032 N676RJCrawford Charles Eldridge · Eastvale, CABuilt 1982 · S/N 24-1323 N67701R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281969 N67705Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15281971 N67708Pischel Tom K · Meadow Vista, CABuilt 1978 · S/N 15281974 N6770NGrant William S · Azle, TXBuilt 1968 · S/N 680090 N6770VDobalian Vaughn E · Jacksonville Beach, FLBuilt 1970 · S/N 700060 N67710Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281975 N67711Cox Linda M · Christiana, TNFirst renewal noticeBuilt 1978 · S/N 15281976 N6771VBrice Michael · Dickinson, NDBuilt 1970 · S/N 700078 N67728Edj Aviation Ltd · Fort Myers Beach, FLBuilt 1978 · S/N 15281983 N6772NHapp Michael E · Valley Center, KSBuilt 1968 · S/N 680083 N67733Righter Douglas D · Bellingham, WABuilt 1978 · S/N 15281986 N6773NMills David J · Combine, TXBuilt 1968 · S/N 680091 N6773VSouthern Mooney Inc · Wilmington, DES/N 700079 N67746Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15281992 N6774UFair Weather Holdings LLC · Centennial, COBuilt 1963 · S/N 2496 N67753Southwinds Export Inc · Kissimmee, FLS/N 15281998 N6775NAirvantage Global LLC · Lake Worth, FLBuilt 1968 · S/N 680085 N67760Farquar Leasing Inc · North Bend, ORBuilt 1978 · S/N 15282002 N67765Guilbeau Austin K · Miami, FLS/N 15282005 N6776NClark Jeff N · Arab, ALBuilt 1968 · S/N 680092 N6776UParmer Jeffrey C · Redondo Beach, CABuilt 1963 · S/N 2498 N67778Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282013 N6777NStephens Mark A · Las Vegas, NVBuilt 1968 · S/N 680086 N6777TNeff Tj · Novato, CAS/N 17701049 N6777ULongmont Mooney · Longmont, CORevoked, canceledBuilt 1963 · S/N 2499 N67787Williams Aviation LLC · Maumelle, ARBuilt 1978 · S/N 15282018 N6778EFriendly Skies Aircraft Leasing LLC · Sacramento, CABuilt 1978 · S/N 17272064 N6778ULift Air Services LLC · Woodland Hills, CABuilt 1963 · S/N 2500 N67792City Of Newport News · Newport News, VABuilt 1981 · S/N 15285309 N67796Dsr Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15282025 N67797Indiana State University · Terre Haute, INBuilt 1978 · S/N 15282026 N6779NHarrigan Jeff S · Bonsall, CABuilt 1968 · S/N 680093

Back to AD 80-25-07 R1