Skip to content

Registered aircraft · 1,310

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-18-04-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-18-04-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-18-04-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-18-04-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-18-04-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-18-04-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.

N94676Dwyer Casey M · Stilwell, KSBuilt 1947 · S/N 4787 N94677Salter Paul E Jr · Jacksonville, FLBuilt 1947 · S/N 4788 N94692Fuller William W · Waxahachie, TXBuilt 1947 · S/N 4803 N94695Wehmer Alan R · Ewa Beach, HIBuilt 1947 · S/N 4806 N94715Schmaltz Dennis B · Rapid City, SDBuilt 1947 · S/N 4826 N94729Murphy Thomas · Spring Hill, TNBuilt 1947 · S/N 4840 N94732Babbitt Dennis L · Crawford, TXS/N 4843 N94742Staff Allen G · Rosanna VicBuilt 1947 · S/N 4853 N94743Flying Wrenches · Buhl, IDS/N 4854 N94746White Wayne · Middleburg, FLBuilt 1947 · S/N 4857 N94765Demarzo Alexander · Flower Mound, TXBuilt 1949 · S/N 5031 N9485KGregory Vernon L · Swansea, SCBuilt 1949 · S/N 4999 N94881Heusinkveld Karen B · San Marcos, TXBuilt 1950 · S/N 5067 N94886Walker Stephen L Trustee · Andover, KSBuilt 1949 · S/N 5014 N94887Moore Gary Trustee · Hillsboro, OHBuilt 1949 · S/N 5015 N94889Springer Thomas W · Gulf Breeze, FLS/N 5017 N94890Yeates Rebecca A · San Angelo, TXBuilt 1949 · S/N 5018 N94894Chappie Michael R · Sidney, OHBuilt 1949 · S/N 5022 N94898Gorham Raymond A · Lock Haven, PABuilt 1949 · S/N 5026 N94JMonica Steven J · Lakeland, FLBuilt 1946 · S/N 1371 N9503VMcdonald Michael A · Village Mills, TXBuilt 1969 · S/N 690004 N9504VMartin James P · Sioux City, IABuilt 1969 · S/N 690005 N9506VLandes Charles A · Independence, ORBuilt 1969 · S/N 690007 N9508VGaines Robert M · Nashville, TNBuilt 1969 · S/N 690009 N9509VMurray Wm Clifton · Socorro, NMBuilt 1969 · S/N 690010 N9510VWertheimer Liam · Sebastian, FLBuilt 1969 · S/N 690011 N9512VJohnmeyer Glenn J · Palmer, AKS/N 700002 N9513VKnapp Bruce G · Newnan, GABuilt 1969 · S/N 700003 N9514VHamilton Jimmy L · Grapevine, TXBuilt 1969 · S/N 700004 N9516VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 700006 N9519VGrant Azalea L · Bremerton, WABuilt 1970 · S/N 700009 N9520VBilewitch Edward I · Sandy Valley, NVBuilt 1969 · S/N 700010 N9523VHarrison Doug A · Yellville, ARBuilt 1969 · S/N 700013 N9524VBuck Mountain Farm · Eureka Springs, ARBuilt 1969 · S/N 700014 N9526VNorth Carolina Aviation Museum And Hall Of Fame · Asheboro, NCBuilt 1970 · S/N 700016 N9527VJohnson Walter H Trustee · White Stone, VABuilt 1970 · S/N 700017 N9529VPatterson Roland O · Semmes, ALBuilt 1970 · S/N 700019 N9530VPeter Giller Aer LLC · Hackettstown, NJBuilt 1970 · S/N 700020 N9535VSamaritan Aviation · Mesa, AZS/N 700025 N9536VSchwartz Robert E · Troy, OHBuilt 1970 · S/N 700026 N9537VBichell Kevin C · Corsicana, TXS/N 700027 N9538VJones Wesley A · Ocala, FLBuilt 1970 · S/N 700028 N9539VBrown Stephen C · Gosport, INBuilt 1970 · S/N 700029 N9541VIowa Mooney Sales Inc · Radcliffe, IAFirst renewal noticeBuilt 1970 · S/N 700031 N9543VRobinson Phillip L · Cabot, ARBuilt 1970 · S/N 700033 N9545VWeber Stephen J · Hastings, MNBuilt 1970 · S/N 700035 N9547VAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1970 · S/N 700037 N9549VRomeo-Delta Inc · Elsie, MIBuilt 1970 · S/N 700039 N9551VTarheel Aircraft Inc · Richlands, NCBuilt 1970 · S/N 700041 N9771MOwen Talbert · University Place, WABuilt 1970 · S/N 700042

Back to AD 94-18-04 R1