Skip to content

Registered aircraft · 40,396

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.

N6629PCrouse William F · Priest River, IDBuilt 1960 · S/N 24-1752 N6629RDempsey Yvonne Grace · Guys Mills, PABuilt 1975 · S/N M-1609 N6629UHanggee Sanford C · Aurora, COBuilt 1963 · S/N 124 N6629WWilcox Chris M · Canajoharie, NYBuilt 1965 · S/N 28-20726 N662BFFoster Robert B · Erie, PABuilt 1997 · S/N RBF01 N662TSchoch Michael Pa · Punta Gorda, FLBuilt 1958 · S/N TD-70 N6630UBartholow Paul V · Santa Rosa, CABuilt 1963 · S/N 125 N6630WRiggin Flight Service Inc · Madison, SDS/N 28-20728 N66313Brazon Brian D · Belle Vernon, PABuilt 1980 · S/N M-2192 N6631UMitchell Caleb C · Hebron, NEBuilt 1963 · S/N 126 N6631WRegistration Pending · Arbela, MORegistration pendingBuilt 1965 · S/N 28-20729 N6631ZClark Ryan D · Sequim, WAS/N M-2190 N6632GGrayson Robert E · Great Falls, MTBuilt 2016 · S/N 109 N6632LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N M-2188 N66337Bales Robert · Osage Beach, MOBuilt 1979 · S/N M-2201 N66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-239 N6633FRegistration Pending · Moses Lake, WARegistration pendingBuilt 1979 · S/N M-2196 N6633JBailey Randall D · Oakley, MIS/N 28-5099 N6633RBlake Anthony B · Hallsville, TXBuilt 1979 · S/N M-2198 N6633WSyf LLC · Okmulgee, OKBuilt 1965 · S/N 28-20731 N66340Wickline Wayne · Flower Mound, TXBuilt 1979 · S/N ME-241 N66344Sallee Philip L · Yucca Valley, CABuilt 1979 · S/N M-2207 N6634BAri Ben Aviator Inc · Fort Pierce, FLBuilt 1979 · S/N ME-234 N6634JMaier Robert B · Duncanville, TXBuilt 1968 · S/N 28-5101 N6634UC A F E Aviation LLC · Gregory, SDBuilt 1963 · S/N 129 N66352Seaplane Adventures LLC · Cheyenne, WYBuilt 1979 · S/N ME-251 N66354Chesson Bradley S · Tacoma, WABuilt 1979 · S/N M-2214 N6635BChandler Jerome P · Redondo Beach, CABuilt 1979 · S/N ME-245 N6635JIndian Head Flying Club LLC · Indian Head, MDBuilt 1968 · S/N 28-5102 N6635UBistline Ladell J Sr · Colorado City, AZS/N 130 N6636DAnderson James M · Little Rock, ARS/N MC-690 N6636LAoa Kissimmee Inc · Kissimmee, FLBuilt 1979 · S/N ME-256 N6636TVincent Air LLC · Carroll, IABuilt 1979 · S/N ME-259 N6636UBurcham Jaime S · Advance, NCBuilt 1963 · S/N 131 N6637JCaison Rodney D · Carrollton, VABuilt 1968 · S/N 28-5105 N6638BAhmed Gedi A · Saint Paul, MNS/N M-2217 N6638HWright Aero Inc · Saint Cloud, MNBuilt 1979 · S/N ME-266 N66399Acord Aviation Co L L C · Chandler, OKBuilt 1983 · S/N 17275988 N6639DBig Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2223 N6639JColoski Dennis J · Marlton, NJBuilt 1968 · S/N 28-5106 N663ABBald Allan D · Alton, NHBuilt 2003 · S/N 80176 N663AFSnelling Peter G · Thornton, PABuilt 1981 · S/N 28-8290060 N663RTRaiders Tigers Flying Club Inc DBA · Houston, TXBuilt 1975 · S/N 17265988 N663RVPlaxco Mitchell O · Huntsville, ALBuilt 2005 · S/N 25201 N6640HSolis Aviation LLC · Carroll, OHBuilt 1975 · S/N 17265520 N6640JHeesch Donald · Nunn, COS/N 28-5107 N6640WAldrich David G · Naples, FLBuilt 1965 · S/N 28-20739 N6641JStratus Business Development LLC · Nashua, NHBuilt 1968 · S/N 28-5109 N6642JFive By Ten LLC · Loveland, COBuilt 1968 · S/N 28-5110 N6642UCrawford Daniel G Trustee · Dryden, MIBuilt 1963 · S/N 137

Back to AD 79-10-03 R2