Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N7445JNosal Ivan · Itasca, ILBuilt 1968 · S/N 28R-30792 N7445PN7445p Flying Club LLC · Union City, CAS/N 24-2634 N7445YCherish Aviation LLC · Woodbridge, VABuilt 1964 · S/N 30-509 N7446JLkn Aviation LLC · Cornelius, NCFirst renewal noticeBuilt 1968 · S/N 28R-30794 N7446YN7446y Aero LLC · Joplin, MOBuilt 1964 · S/N 30-510 N7447JWiley Calvin · Summer Shade, KYBuilt 1968 · S/N 28R-30795 N7448PBurshem Ben E · Bay City, WIBuilt 1961 · S/N 24-2637 N7449PAshcroft James K · Hurricane, UTBuilt 1961 · S/N 24-2638 N7449YMiddle Georgia Aviation Inc · Cochran, GABuilt 1964 · S/N 30-513 N7450JBuchanan David · Elkin, NCBuilt 1968 · S/N 28R-30799 N7451JMoore Jimmy I · Beach City, TXBuilt 1968 · S/N 28R-30800 N7452PTimothy A Cox · Coshocton, OHBuilt 1961 · S/N 24-2641 N7453YStratus Air Services LLC · Punxsutawney, PABuilt 1964 · S/N 30-516 N7454PCreation Industries LLC · Middlefield, OHBuilt 1961 · S/N 24-2644 N7454YOrthner Aviation LLC · Chattanooga, TNBuilt 1964 · S/N 30-517 N7455YTowns Bobby · Nashville, TNBuilt 1964 · S/N 30-518 N7456JSchwier Ronald G Jr · Bloomfield, NJBuilt 1968 · S/N 28R-30954 N7456PInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 24-2646 N7457JMoretti Stephen B · Cranston, RIBuilt 1968 · S/N 28R-30808 N7457YPeter Prince Aviation Center LLC · Milton, FLBuilt 1964 · S/N 30-520 N7458JReeves Stephen · Watford City, NDBuilt 1968 · S/N 28R-30810 N7459JEvans Charles Dewayne · Cumby, TXBuilt 1968 · S/N 28R-30811 N745ATLysenko Aleksandr D · Medford, NJBuilt 1977 · S/N 28R-7703078 N7460PStevenson George Otis · Wheatland, WYBuilt 1961 · S/N 24-2650 N7462JFirmino Paulo · Gainesville, TXBuilt 1968 · S/N 28R-30814 N7463JUnusual Attitudes LLC · Bates City, MOS/N 28R-30815 N7463YSkyway Flight Service LLC · Jonesboro, ARBuilt 1964 · S/N 30-526 N7466PJmj Aviation LLC · Kalispell, MTS/N 24-2657 N7467JDouble Bridges Aviation · Enterprise, ALBuilt 1968 · S/N 28R-30819 N7468PMarlott Corwin · Spokane, WAS/N 24-2659 N7468YThys Edouard B · Olympic Valley, CABuilt 1964 · S/N 30-531 N7469JSussex Aero Maintenance Inc · Georgetown, DEBuilt 1968 · S/N 28R-30822 N7469YStader Stacy H · Altoona, FLBuilt 1964 · S/N 30-532 N746BCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1974 · S/N 28R-7435187 N7470JPrairie View Energy LLC · Granite Falls, MNBuilt 1968 · S/N 28R-30823 N7470PCarey Transport · Baker City, ORBuilt 1961 · S/N 24-2661 N7471YLi Yilin · Alma, MIBuilt 1964 · S/N 30-536 N7473YSale Reported · Palmer, AKSale reportedBuilt 1964 · S/N 30-538 N7474JHorton James D · Las Vegas, NVS/N 28R-30827 N7475YOverseas Aviaton Inc · Wilmington, DEBuilt 1964 · S/N 30-540 N7476JHernandez Miguel A · Brownsville, TXBuilt 1968 · S/N 28R-30831 N7476YWilliam L Stewart Code Supplies Inc · Rossville, TNBuilt 1964 · S/N 30-541 N7478JGallo Gerald F · Worcester, MABuilt 1968 · S/N 28R-30834 N7478PHanderson Ronald J Sr · Sitka, AKS/N 24-2671 N7479JHouse Nancy L · Sherwood, ARBuilt 1968 · S/N 28R-30835 N7479PThomas Mark · Princeton, KYBuilt 1961 · S/N 24-2672 N747JSAlameda Aero Club · Alameda, CABuilt 1967 · S/N 28R-30365 N747KPDeer Howard W III · Reston, VABuilt 1966 · S/N 30-1223 N747PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1974 · S/N 34-7450112 N747RCConti Richard T · Orinda, CABuilt 1978 · S/N 34-7970068

Back to AD 97-01-01 R1