Skip to content

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N2811CBeyer James C · Fayetteville, TNBuilt 1954 · S/N 26354 N2811NBlake Trenton D · Anderson, INBuilt 1947 · S/N 13072 N28123Webster Bart · Rexburg, IDBuilt 1940 · S/N 5-109 N2812CSmallwood Nathan M · Ellicott City, MDS/N 26355 N2812LHarris Partnership · Conway, ARBuilt 1967 · S/N 17256012 N2812NCook-Berry Timothy · Brooklyn, NYBuilt 1947 · S/N 13073 N2812UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250412 N2813CFray Jonathan C · Wasilla, AKBuilt 1954 · S/N 26356 N2813LFoster Neal W · Nome, AKBuilt 1967 · S/N 17256013 N2813NRussell Richard E · Holt, FLBuilt 1947 · S/N 13074 N2814CStone Robert D · Anchorage, AKBuilt 1954 · S/N 26357 N2814LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 17256014 N2814NGrahn Victor A Jr · Bellevue, MIBuilt 1947 · S/N 13075 N2814VCentral Ohio Soaring Association · Marion, OHBuilt 1974 · S/N 15076290 N2815CCooper David A · Mc Kittrick, CAS/N 26358 N2815NScialabba John E · Columbus, OHBuilt 1947 · S/N 13076 N2815UHarris Tony James · Stanley, NCBuilt 1963 · S/N 17250415 N2816HR & R Outfitters LLC · Kalispell, MTS/N 3441 N28171Wjm Aviation LLC · Friendswood, TXBuilt 1940 · S/N 4631 N2817NEagles Nest Projects Wisonsin · Burlington, WIS/N 13078 N2817UAero Ventures Inc · Yukon, OKBuilt 1963 · S/N 17250417 N2818CSchmidt Wolf E · Anchorage, AKBuilt 1954 · S/N 26361 N2818UWard Jasper Eugene · Telford, TNFirst renewal noticeS/N 17250418 N2819CLanis Scott E · North Pole, AKBuilt 1954 · S/N 26362 N2819NSpeer Melissa · Los Angeles, CABuilt 1947 · S/N 13080 N2819SBeale Frank B II · Bowling Green, VABuilt 1967 · S/N 15066719 N2819UGartner Thomas M · Newton, KSBuilt 1963 · S/N 17250419 N281DBMac Mic Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N B-281 N281RDWait Rexford J · Vista, CABuilt 1938 · S/N 16087 N281WRezich & Rezich Aviation Consulting Inc · Winnebago, ILBuilt 1940 · S/N 106 N28205Toman Michael · Painesville, OHBuilt 1940 · S/N 4-1132 N2820LHarrington Thomas W Jr · Cumming, GAS/N 17256020 N2821NJohnson Mark L · Hood River, ORBuilt 1947 · S/N 13082 N2821SHancock Jeffrey A · Jacksonville, TXS/N 15066721 N2821UPelotte Raymond J · Waterville, MEBuilt 1963 · S/N 17250421 N2822CNeverman Walter M · Albany, WIBuilt 1954 · S/N 26365 N2822LRobertson IV Henry B · Owensboro, KYS/N 17256022 N2823CJones Adam · Fairbanks, AKBuilt 1954 · S/N 26366 N2823NByrne David D · Fountain Hills, AZBuilt 1947 · S/N 13084 N2823SSpark Aero LLC · Christiansburg, VABuilt 1965 · S/N 15062301 N2823UPowell Mark J · Chelsea, MIBuilt 1963 · S/N 17250423 N28245Howe Norman E · Wausau, WIBuilt 1940 · S/N 5-164 N2824CReilly Richard J · St Paul, MNBuilt 1954 · S/N 26367 N2824KFlannery Robert P · Durango, COS/N 5551 N2824SGolf Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 15066724 N2825CSouza Clifford A · Pattersonville, NYBuilt 1954 · S/N 26368 N2825HMayo Charles S · Woodlawn, TXBuilt 1946 · S/N 3450 N2825SShore Luke S · Elkin, NCBuilt 1967 · S/N 15066725 N28266Carnevale Victor N · Fayetteville, NCBuilt 1982 · S/N 1 N2826CSolstice Joshua A · Anchorage, AKS/N 26369

Back to AD 94-05-05 R1