Skip to content

Registered aircraft · 40,394

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N9950WPlane Jane Aviation LLC · Lincoln, NEBuilt 1967 · S/N 28-23495 N9950YAnders Rod D · Wasta, SDS/N 7GCB-156 N99517Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276459 N9951DDicenzo Eugene N · Cumberland, RIBuilt 1959 · S/N 22-6739 N9951V9951v Aircraft Leasing LLC · Spanish Fork, UTS/N 17264569 N99527Delta State University · Cleveland, MSBuilt 1985 · S/N 17276460 N9952DLynch John E · Bourbonnais, ILBuilt 1959 · S/N 22-6740 N99532Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276462 N9953DNiner Niner Five Three Delta LLC · Marshall, WIS/N 22-6742 N9953YBlock Larry F · Palmer, AKS/N 7GCB-157 N9954DJoy Derek T · Bad Axe, MIBuilt 1959 · S/N 22-6743 N99553Jka LLC · Notasulga, ALBuilt 1985 · S/N 17276465 N99554Briner Micah · Martinsville, INBuilt 1977 · S/N C-1 N9955QWerba Travis J · Anchorage, AKBuilt 1955 · S/N 18-3918 N9955RWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTS/N TD-426 N9955UMatteson Gary E · Monmouth, ORBuilt 1977 · S/N AA5A0355 N9956RMiga Holdings LLC · Flower Mound, TXBuilt 1960 · S/N TD-394 N9957DLinett Michael J · Elsmere, DEBuilt 1959 · S/N 22-6746 N9957EReisman Richard H · Montrose, COBuilt 1979 · S/N 17272298 N9957QHarmon Michael D · Mansfield, SDBuilt 1954 · S/N 54-2535 N9957UTurner Steven R · Westfield, INBuilt 1977 · S/N AA5A0357 N99583Motz Gary A · Bemidji, MNBuilt 1985 · S/N 17276471 N99589Kingsky Flight Academy LLC · Lakeland, FLBuilt 1985 · S/N 17276472 N9958DMoore William H · Johnstown, COBuilt 1959 · S/N 22-6748 N9958YZimmerman Tom V Jr · Fairbanks, AKFirst renewal noticeBuilt 1962 · S/N 7GCB-158 N99598Registration Pending · Argyle, TXRegistration pendingBuilt 1985 · S/N 17276474 N9959DJohnson Steven Donald · Pardeeville, WIBuilt 1959 · S/N 22-6749 N9959UGunji Harold H · Lawrenceville, GABuilt 1977 · S/N AA5A0359 N995CCN995cc LLC · Fredericksburg, TXBuilt 2000 · S/N 9913CC N995JAN995ja LLC · Ft Lauderdale, FLBuilt 1974 · S/N 17263989 N995RVRhoden Richard C · Friendswood, TXBuilt 2023 · S/N 90685 N995WN995w LLC · Salem, ORBuilt 1958 · S/N 18-6676 N99606Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276478 N9960UFletchair Inc · Comfort, TXBuilt 1977 · S/N AA5A0360 N9961ERuryk Jonathan D · Pineville, LABuilt 1979 · S/N 17272300 N9961UAam Leasing LLC · Zeeland, MIBuilt 1977 · S/N AA5A0361 N9961VCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17264579 N9961WViper Enterprises LLC · Rolla, MOBuilt 1967 · S/N 28-23508 N9962UJones Randall Bryan · Palm City, FLBuilt 1977 · S/N AA5A0362 N9962WSuggs Kaycen M · Grifton, NCBuilt 1967 · S/N 28-23509 N9963DBurlak David M · Waverly, VABuilt 1959 · S/N 22-6754 N9963EDenski David T · Plymouth, MIBuilt 1979 · S/N 17272301 N9963URansom James R · Modesto, CABuilt 1977 · S/N AA5A0363 N9964LHess Garrett J · Fullerton, CABuilt 1986 · S/N 17276652 N9964WRawlins James III · Saint Charles, MOBuilt 1967 · S/N 28-23511 N9966DZiemann Shaun · Jasper, INBuilt 1959 · S/N 22-6757 N9966VLeisner David L · Palmer, AKBuilt 1974 · S/N 17264584 N9967YDexter Fred H · Live Oak, FLBuilt 1963 · S/N 7GCB-177 N9968VCynthiana Flying Group Corp · Cynthiana, KYBuilt 1974 · S/N 17264586 N9968WWitter Gregory J · Overton, NVBuilt 1967 · S/N 28-23515

Back to AD 79-10-03 R2