Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056 N2557LSparks Ryan J · Peculiar, MOBuilt 1967 · S/N 17255757 N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2558LHoecher Robert · Anchorage, AKS/N 17255758 N2558RKahn Steven P · Boise, IDBuilt 1967 · S/N 18258258 N2559LFlying Circus LLC · Bridgeport, WVBuilt 1967 · S/N 17255759 N2559QJordan Valley Aviation LLC · Jordan Valley, ORBuilt 1966 · S/N 18257759 N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N2561QMariposa Aviation Inc · East Wenatchee, WABuilt 1966 · S/N 18257761 N2561RHeber Valley Flying Club · Park City, UTBuilt 1967 · S/N 18258261 N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061 N2562LWilkey Paul W · Sullivan, INBuilt 1967 · S/N 17255762 N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762 N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262 N2564RBusse William J · Twin Lakes, WIBuilt 1967 · S/N 18258264 N2564VMay Matthew J · Weatherford, TXBuilt 1974 · S/N 177RG0617 N2565RSanders David D · Alvin, TXBuilt 1967 · S/N 18258265 N2566RRastetter Harold · Douglaston, NYBuilt 1967 · S/N 18258266 N2567RGone Flying LLC · Loveland, OHBuilt 1967 · S/N 18258267 N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068 N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336 N2570LHerman John K Jr · Flagler, COBuilt 1967 · S/N 17255770 N2570QGolden Thomas J · Bishop, GAS/N 18257770 N2570RSkyblazers LLC · Boones Mill, VABuilt 1967 · S/N 18258270 N2571LClements Jim L · Cushing, OKBuilt 1967 · S/N 17255771 N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485 N2572RMladejovsky Michael G Trustee · Paulden, AZBuilt 1967 · S/N 18258272 N2572VJarvis Michael Lynn · Orem, UTBuilt 1974 · S/N 177RG0620 N2572XC S Enterprises Llp · Morristown, TNBuilt 1965 · S/N P206-0072 N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173 N2573VOldfield Raymond M Jr · Waupaca, WIBuilt 1974 · S/N 177RG0621 N2573XSkd LLC · Spokane, WABuilt 1965 · S/N P206-0073 N2574RChauvin Junius · Franklin, LAS/N 18258274 N2575VStone Tommy R · Jacksonville Beach, FLBuilt 1974 · S/N 177RG0622 N2575X360 Solo LLC · San Martin, CABuilt 1965 · S/N P206-0075 N2576LRiggin Flight Service Inc · Madison, SDS/N 17255776 N2576QHamilton Steve · Carson City, NVBuilt 1966 · S/N 18257776 N2577LKim L Jensen · Enoch, UTBuilt 1967 · S/N 17255777 N2577RSchomaker Michael J · Pleasanton, CABuilt 1967 · S/N 18258277 N2581VMink Stephen Earl · Walnut Creek, CABuilt 1974 · S/N 177RG0625 N2582LRichardson Michael Todd · Wilkesboro, NCS/N 17255782 N2582Q82q LLC · Glenwood, MDS/N 18257782 N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282 N2583LMontgomery Robert A · Hampstead, NCBuilt 1967 · S/N 17255783 N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283 N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083 N2585LAerospace Quality LLC · Piggott, ARS/N 17255785 N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285

Back to AD 72-03-03 R3