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.

N72424Magill William J · Moncks Corner, SCS/N 241523 N7244PPaden Stanley R · Diamond Bar, CABuilt 1961 · S/N 24-2418 N7244YJ Mac Aviation Services LLC · Andalusia, ALBuilt 1964 · S/N 30-269 N7245PMontcalm Kevin L · Mansfield, LABuilt 1960 · S/N 24-2419 N7246PAlex John R · Turner, MTBuilt 1960 · S/N 24-2420 N7246YMoyer Thomas L · Fayetteville, GABuilt 1964 · S/N 30-271 N7247PRegistration Pending · Caribou, MERegistration pendingBuilt 1960 · S/N 24-2421 N7248PN7248p Ltd · Wallkill, NYBuilt 1960 · S/N 24-2424 N7249PDavis Scott · Bingham, NEBuilt 1960 · S/N 24-2425 N7249YCt Capital LLC · Austin, TXS/N 30-274 N724BMJensen William B Jr · Huntington, NYBuilt 1968 · S/N 24-4802 N7250PTrayer Kevin B Trustee · Haslet, TXBuilt 1961 · S/N 24-2426 N7252PSchaefer Hugh W · Merrick, NYBuilt 1961 · S/N 24-2428 N7252YGuyer James · Billings, MTBuilt 1964 · S/N 30-277 N7253YJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1964 · S/N 30-278 N7254YSpldkd LLC · New Richmond, WIBuilt 1964 · S/N 30-280 N7255PKubik Rodrick D · Waukee, IAFirst renewal noticeS/N 24-2431 N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290 N7258YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-291 N7260PPotts Leah Marie · Roanoke, VABuilt 1961 · S/N 24-2436 N7260YDeuce Aire LLC · Middletown, DEBuilt 1964 · S/N 30-294 N7261YKocak Robert G Jr · Peoria, AZBuilt 1964 · S/N 30-295 N7262PParker Dennis Scott · Lubbock, TXBuilt 1961 · S/N 24-2438 N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298 N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299 N7265Walker Teresa L · Enid, OKBuilt 1963 · S/N 24-3454 N7265PQuinlan John H · Claxton, GABuilt 1961 · S/N 24-2441 N7266PGrover Donald G · Canby, ORBuilt 1961 · S/N 24-2442 N7269PBoucher Bobbi · Fredericksburg, VABuilt 1961 · S/N 24-2445 N7271CChesley James Philip · Mesa, AZBuilt 1975 · S/N 28R-7635098 N7272PMellema Tammo · Dalhart, TXBuilt 1961 · S/N 24-2448 N7272YToucan Aviation LLC · Bentonville, ARBuilt 1964 · S/N 30-311 N7273FB& G Air LLC · Hudson, FLBuilt 1976 · S/N 34-7770055 N7273PBrice Brandon Scott · Denver, COBuilt 1961 · S/N 24-2449 N7274PKeil Ronald B · Lapeer, MIBuilt 1961 · S/N 24-2450 N7275YCross John Benjamin · Lake Charles, LABuilt 1964 · S/N 30-314 N7277YDouble A Investments Inc · Rowland, NCBuilt 1964 · S/N 30-315 N7278CAndrews Jeb C · Monroe, LABuilt 1975 · S/N 32R-7680044 N7279YChormicle James R · Littlerock, CABuilt 1964 · S/N 30-317 N727DSYso Noz LLC · Grandville, MIBuilt 1958 · S/N 24-276 N727HALinfield Steven J · Westminster, MDBuilt 1978 · S/N 28R-7803289 N727HSSandstar Aviation LLC · Lewes, DES/N 28R-7335432 N727PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250110 N727PGDowns Donald S · Lake City, FLBuilt 1977 · S/N 28R-7703227 N727RMMarkle Robert L Jr · Cranberry Township, PABuilt 1965 · S/N 30-806 N727SDStable Air LLC · Leonardtown, MDBuilt 1976 · S/N 32R-7780060 N7281PGuardian Peaks Airways LLC · Portland, ORBuilt 1961 · S/N 24-2458 N7281YGo For Flight LLC · Minneapolis, MNBuilt 1964 · S/N 30-319 N7284CSeed Richard J IV · Wicomico Church, VAS/N 28R-7635099 N7286YReagan Scott Lllp · Mount Pleasant, SCBuilt 1964 · S/N 30-324

Back to AD 97-01-01 R1